Extra Free Day For Everyone- What Will You Do With Yours? Learn More About Excel Dates?


Every four years we get an extra day, how cool is that, so just what will you do with your extra day this February?.

You could use it to learn more about date calculations in Excel?…Why not?

You could plot the leap years that have gone or are to come. Theres a few ways to do this in Excel. Here are two

You can use the formula-

=DAY(DATE(year,month+1,1)-1)

Month is the MONTH for which you want to return the number of days and YEAR is the year. This formula calculates the first day of the next month and subtracts 1, which gives the last day of the current month. The DAY function then gives the day of the month.

In my formula I have made the number 2 stored in cell C1 as an absolute reference as I in this formula want to always have the month as February.

Or if you have the Analysis Toolpack you can use the EOMONTH function, it’s is only available if this is installed otherwise you will get an error.

So, assuming you have the Toolpack installed…..

You can use the following formual syntax

=EOMONTH(Start date,how many months before or after start date)

You can see in my example I know exactly which are leap years….

Share with us what you will be doing with your extra day….

Other Excel Tips You Might Like

1. Convert Excel Dates- Days To Months Using the DAY() function

2. Find The Difference Between Two Dates Using DATEDIF

Barbara

Barbara is an experienced data analyst with over 20 years of experience. Author of the How To Excel At Excel Top 50 Excel tips Ebook, YouTuber and Excel Blogger.

Recent Posts