1. creating a macro that will put the expiry month in letters (for…

Question 1. creating a macro that will put the expiry month in letters (for… 1. creating a macro that will put the expiry month in letters (for example: Nov).  2. Record or Write a Macro, that  calculate the bike status using the logic:If a a product expiry year is the current year, then display “Expiring this year”Otherwise, if the expiry year of the product has passed, display “Expired”?In all other cases, display ” not yet” Also, create a macro button for it in “Data” sheet (at the bottom) so that it is easier to re-run the macro.?    Engineering & Technology Industrial Engineering Operations Management BUS 308 Share QuestionEmailCopy link Comments (0)