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?

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.

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.

Use fill handle to fill.

Cool, we made it. See you next time.