How to calculate total number of days in a month

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

good to have you back here.

in many cases you need this info


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


hope it helps, Cheers, Christiaan

1 Like

Hi Christiaan,
Thanks a lot it worked.


1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.