finding the last day of the month

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a spreadsheet that has a date column listing dates going back 3 years,
each month has about 50 line items with different days of the month, it there
a way to create a new column that lists the last day of the month for each
line item? For example if the date was August 9, 2007 the formula would
return August 31,2007.

Thanks
 
Assume the date is in A3

=DATE(YEAR(A3),MONTH(A3)+1,)

will return the date of the last day of the month for the date in A3



--


Regards,


Peo Sjoblom
 
With
A2: (a date)

If you have the Analysis ToolPak installed:
=EOMONTH(A2,0)

If you don't....then try this:
=DATE(YEAR(A2),MONTH(A2)+1,0)

Does that help?
--------------------------

Regards,

Ron (XL2003, Win XP)
Microsoft MVP (Excel)
 
Great solutions!! Thanks for the help...

Ron Coderre said:
With
A2: (a date)

If you have the Analysis ToolPak installed:
=EOMONTH(A2,0)

If you don't....then try this:
=DATE(YEAR(A2),MONTH(A2)+1,0)

Does that help?
--------------------------

Regards,

Ron (XL2003, Win XP)
Microsoft MVP (Excel)
Click to expand...
 
I'm glad I could help, Charles......Thanks for the feedback.

Regards,

Ron (XL2003, Win XP)
Microsoft MVP (Excel)
 
Back
Top