Excel: Determine Fiscal Year (FY) Quarter Based on Dates


I have a MS Access table where one column has dates i.e. 12/1/12, 7/15/14 and another column where I need the quarter for each date. The quarters are based on the following months: Q1 = 10,11,12 Q2 = 1,2,3 Q3 = 4,5,6 Q4 = 7,8,9 Is there a formula that I can put in the Validation Rule (under the Field Properties) or something to have this field be automatically determined? If not, will it only work in a query?? Is there a VBA for this?


This question generated 20 answers. To proceed to the answers, click here.

This thread is current as of July 03, 2014.


For more resources for Microsoft Excel