Take a Guess to Win Windows 10 Pro Key!
previous arrow
next arrow
Slider

How to Determine the Number of Days of any Month in any Year?

Date:2021-12-4 Author:Sandra

If I now ask you how many days there are in this month, you should be able to answer 31 days right away. Then let me ask you how many days are there in February 2050? You may need to think about it for a while and answer 28 days. So how do we use formulas in Excel to quickly determine the number of days in any month?

How to Determine the Number of Days of any Month in any Year?

There are a lot of formulas for handling date. But no one can calculate the days of the month directly. So, how to do this in a simple way.

Firstly, we can use the EOMONTH function to get the date of the last day of the month.

Just type =EOMONTH(DATE(A2,B2,1),0) in cell C2 and press Enter key.

How to Determine the Number of Days of any Month in any Year?

Now we can see the last day of September in 1903 was September 30. we can easily know that the number of days of September in 1903 is 30. What should we do if we want to extract the number of days? That’s DAY function.

How to Determine the Number of Days of any Month in any Year?

Use fill handle to fill.

How to Determine the Number of Days of any Month in any Year?

Cool, we made it. See you next time.

Copyright Statement: Regarding all of the posts by this website, any copy or use shall get the written permission or authorization from Myofficetricks.

Leave a Reply

Your email address will not be published. Required fields are marked *