Is there a function that gives us the last day of a month
Assuming A1 contains the date: 11/10/2005
If you want the number of days in a given month:
=DAY(DATE(YEAR(A1),MONTH(A1)+1,0))
If you want the last day of a given month:
=DATE(YEAR(A1),MONTH(A1)+1,0)
HTH,
Paul
"Grd" wrote in message
...
Hi,
I need to get the last day of a month i.e 30/nov/05 out of todays date.
How do I go about this? Its driving me crazy.
Any help appreciated
Gordon
|