You’ve learned how Excel stores dates as numbers, and how, because of that, you can format a date in Excel with codes. There are various codes for months, days, and years. There are not, however, codes for quarters. So you if want to turn 10/26/15 into 4, because that date is in the fourth quarter, you’ll have to be a little creative.
- Come up with an excel function using =LOOKUP that will return quarters.
- Develop a visual basic function that takes a date and returns the quarter.
- Write a VBA function called =QY that returns the quarter and year, such that 1/8/15 would return: Q1 ‘15