Fiscal Calendar in Excel generates an elegant calendar based on the year you type into cell J1, with July 1 being the first day of the fiscal year. The fiscal month begins on the last Monday of the previous month with a full work week (5 days). For example, the Monday ten days before Thanksgiving will be the first week of fiscal month December (November 13 in 2017). Fiscal Calendar in Excel allows you highlight certain business days each month and it'll highlight holidays every year.
If you...