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…
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.
Step 1: Input the formula =DAY(
So, let’s begin by inputting the DAY Function which is as follows:
Step 2: Input the required values in the formula
The following formula requires serial number.
Step 3: Input the formula =EOMONTH(
So, we will input another function, i.e. the EOMONTH Function which is as follows:
Step 4: Input the required values in the formula
The following formula requires start date and months.
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.
Then in the case of months, we will jot down 0, as the EOMONTH Function does the rest of the work…
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:
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!
So, it’s easy, isn’t it?