Find days in a Month

J

Jman

I want to know how many days are in a month.
In A1 I have a date ex. 3/3/08.
In B1 i want to give me total days in that month.

Is there a formula for that.
 
J

Jman

Jman said:
I want to know how many days are in a month.
In A1 I have a date ex. 3/3/08.
In B1 i want to give me total days in that month.

Is there a formula for that.
Click to expand...

nevermind i got it..

=DAY(DATE(YEAR(A1),MONTH(A1)+1,0))
 
P

Peo Sjoblom

One way


=DAY(DATE(YEAR(A1),MONTH(A1)+1,0))


format as general



--


Regards,


Peo Sjoblom
 
T

T. Valko

Take your pick:

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

=DAY(DATE(YEAR(A1),MONTH(A1)+1,0))

This one requires the Analysis ToolPak add-in be installed on Excel versions
prior to Excel 2007.

=DAY(EOMONTH(A9,0))
 
Top