Tom’s Tutorials For Excel: Calculating a Month’s Fiscal Quarter Number
Most businesses account their annual operations on a January to December schedule. For those businesses, their quarterly calendar looks like this
Quarter 1: January, February, March
Quarter 2: April, May, June.
Quarter 3: July, August, September.
Quarter 4: October, November, December.
For this common accounting cycle, and as shown in the following picture, you can determine…