- Hot Topics
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 3, 2014.
For more resources for Microsoft Excel:
This article includes the following tags:
- Microsoft Excel