I would like to find the last day of a month
 

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

I would like to find the last day of a month
 

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

HTH,
Bernd

I would like to find the last day of a month
 

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

--
Gary's Student


"Grd" wrote:

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

I would like to find the last day of a month
 

Exactly it

thanks

S

" wrote:

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

HTH,
Bernd