I would like to find the last day of a month

[Guest]

Hi,

Someone has suggested using the analysis toolpak. Is it possible to do this
withouth the toolpak and do it using date functions.

thanks

suzie

 

[bplumhoff]

=date(year(a1),month(a1)+1,0)

HTH,
Bernd

 

[Guest]

Use the DATE() function
if the year is in A1 and the month is in A2, then in A3
=DATE(A1,A2+1,0)
for example:
2006
4
4/30/2006

 

[Guest]

Exactly it

thanks

S