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
Enterprise-grade ITSM, for every business Icon
Enterprise-grade ITSM, for every business

Give your IT, operations, and business teams the ability to deliver exceptional services—without the complexity.

Freshservice is an intuitive, AI-powered platform that helps IT, operations, and business teams deliver exceptional service without the usual complexity. Automate repetitive tasks, resolve issues faster, and provide seamless support across the organization. From managing incidents and assets to driving smarter decisions, Freshservice makes it easy to stay efficient and scale with confidence.
Try it Free
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