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
$300 Free Credits for Your Google Cloud Projects Icon
$300 Free Credits for Your Google Cloud Projects

Start building on Google Cloud with $300 in free credits. No commitment, no credit card required until you're ready to scale.

Launch your next project with $300 in free Google Cloud credits—no strings attached. Test, build, and deploy without risk. Use your credits across the entire Google Cloud platform to find what works best for your needs. After your credits are used, continue with always-free tier services. Only pay when you're ready to scale. Sign up in minutes and start exploring.
Start Free Trial
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