Return Number of day per month

[cgx79]

Hi,

How to i get the total number of day per month using function
not in marco

 

[Frank Kabel]

Hi
if A1 contains a date try the following
=DAY(DATE(YEAR(A1),MONTH(A1)+1,0))
This returns the n umber of days for the month in A1

 

[Peo Sjoblom]

This ingenuous formula by Daniel Maher does it

=32-DAY(A1-DAY(A1)+32)

where the date is in A1

 

[2rrs]

Hi,

How to i get the total number of day per month using function n
not in marco.

Message posted

you coulld try this also:

=DAY(EOMONTH(A72,0))