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 don't like the automated dates, manually set them on the second sheet.

Features

  • highlight the first day of the fiscal month beginning on the last Monday of full work week the previous month
  • fiscal year starts on July 1
  • create a fiscal calendar
  • highlight business day x
  • show all holidays for this year

Project Samples

Project Activity

See All Activity >

Categories

Spreadsheet, Calendar

License

GNU General Public License version 3.0 (GPLv3)

Follow Fiscal Calendar in Excel

Fiscal Calendar in Excel Web Site

Other Useful Business Software
Our Free Plans just got better! | Auth0 Icon
Our Free Plans just got better! | Auth0

With up to 25k MAUs and unlimited Okta connections, our Free Plan lets you focus on what you do best—building great apps.

You asked, we delivered! Auth0 is excited to expand our Free and Paid plans to include more options so you can focus on building, deploying, and scaling applications without having to worry about your security. Auth0 now, thank yourself later.
Try free now
Rate This Project
Login To Rate This Project

User Reviews

Be the first to post a review of Fiscal Calendar in Excel!

Additional Project Details

Operating Systems

Windows

Intended Audience

End Users/Desktop

Programming Language

Visual Basic for Applications (VBA)

Related Categories

Visual Basic for Applications (VBA) Spreadsheet Software, Visual Basic for Applications (VBA) Calendar Software

Registered

2017-01-21