Useful Hacks, Reviews, Tips and Tricks of anything under the moon and the sun.

Calculate The Number Of Days In A Month in Excel

No comments
I just came from the gym and its already past 7PM, Dingdong.. my messenger popup a window.

Fed
Hey are you still there?


I answered
No. Im not here anymore.


Fed
C'mon men, need help. Do you know how to calculate the number of days in a month in excel sheet?


Me
Give me a minute.


I open up my browser and ask Mr. Google. Then theres the formula.

Me.
To calculate the number of days in a month, use the following formula.

=DAY(DATE(YEAR(A1),MONTH(A1)+1,1)-1)
Where A1 contains a date.

I already tested it on MS Excel 2003. It should be working.



Fed
Thanks bro.

No comments :

Post a Comment