Excel Guides

Leap Years and Fiscal Periods in Excel

Leap years and fiscal periods in Excel can be a bit confusing. Here's a quick rundown on how they work:

Every four years is a leap year. This means that there are 366 days in that year, as opposed to the usual 365. The extra day is added in February, and is called a "leap day."

Fiscal periods are different from calendar years, and may be shorter or longer. For example, a company's fiscal year could start in April and end in March. In this case, the company would have two fiscal periods in one calendar year.

In Excel, you can use the DATE function to calculate dates based on the fiscal year. For example, if your fiscal year starts on April 1st, you can use the following formula to calculate the date of the first day of the fiscal year:

=DATE(YEAR(TODAY()),4,1)

You can also use the DATE function to calculate leap years. The following formula will return TRUE if the year is a leap year:

=MOD(YEAR(TODAY()),4)=0

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.