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
Gen AI apps are built with MongoDB Atlas Icon
Gen AI apps are built with MongoDB Atlas

Build gen AI apps with an all-in-one modern database: MongoDB Atlas

MongoDB Atlas provides built-in vector search and a flexible document model so developers can build, scale, and run gen AI apps without stitching together multiple databases. From LLM integration to semantic search, Atlas simplifies your AI architecture—and it’s free to get started.
Start 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