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
AI-generated apps that pass security review Icon
AI-generated apps that pass security review

Stop waiting on engineering. Build production-ready internal tools with AI—on your company data, in your cloud.

Retool lets you generate dashboards, admin panels, and workflows directly on your data. Type something like “Build me a revenue dashboard on my Stripe data” and get a working app with security, permissions, and compliance built in from day one. Whether on our cloud or self-hosted, create the internal software your team needs without compromising enterprise standards or control.
Try Retool 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