If you have a bunch of dates and you want to know the number of days in month or particular month in your datasheet, here’s what you can do…

Example:

Number of Days in Month

As you can see in the example above, we have a bunch of dates and we want to calculate the days in the Month which is shown in the Date.

Number of Days in Month

Step 1: Input the formula =DAY(

So, let’s begin by inputting the DAY Function which is as follows:

=DAY(

Step 2: Input the required values in the formula

The following formula requires serial number.

Number of Days in Month

Step 3: Input the formula =EOMONTH(

So, we will input another function, i.e. the EOMONTH Function which is as follows:

=EOMONTH(

Step 4: Input the required values in the formula

The following formula requires start date and months.

Number of Days in Month

The start date will be the Date from which we are targeting the month to know the no. of the days present in the same.

Number of Days in Month

Then in the case of months, we will jot down 0, as the EOMONTH Function does the rest of the work…

Number of Days in Month

So, after inputting 0 in months, we will close the EOMONTH Function and after the same, we will close the DAY Function as well.

Step 5: Cross- check the formula and proceed

By this, our overall formula becomes as follows:

=DAY(EOMONTH(B2,0))

Number of Days in Month

Now all we have to do is press enter, and there you go, the answer is 31, there are 31 days in the month of July (23-07-2019).

All you have to do now, is drag down the formula till it’s required and your work will be simply done!

Number of Days in Month

So, it’s easy, isn’t it?