Is there a function that gives us the last day of a month
Where A1 contains a date:
If you have the Analysis ToolPak installed:
=EOMONTH(A1,0)
Using regular Excel functions:
=DATE(YEAR(A1),MONTH(A1)+1,0)
Does that help?
€¢€¢€¢€¢€¢€¢€¢€¢€¢€¢
Regards,
Ron
"Grd" wrote:
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
|