How to calculate total number of days in a month

1

Hi,
Is there a formula to count the total number of days in a month. January has 31 days, so the answer should be only “31” .

January - 31
February - 28
March - 31

2

good to have you back here.

in many cases you need this info

image

The EndOfMonth() formula is your friend and combined with Day() you get the number 30 (in our example)

EndOfMonth(Today(),0).Day()

hope it helps, Cheers, Christiaan

3

Hi Christiaan,
Thanks a lot it worked.

Regards
Rajesh