I want last days of the month in cells A1-A12

  • Thread starter Thread starter hamiltoncruiser
  • Start date Start date
H

hamiltoncruiser

How do I tell Excel 2007 to calculate the last day of the month

.....Lisa
 
How do I tell Excel 2007 to calculate the last day of the month

....Lisa
Click to expand...

=DATE(year(dt),month(dt)+1,0)

or

=EOMONTH(dt,0)

dt can be an actual date, or a reference to a cell containing a date.
--ron
 
If this function is not available, and returns the #NAME? error, install and
load the Analysis ToolPak add-in.


--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"hamiltoncruiser" escreveu:
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Last working day of a month 12
A formula that autofills by trend rather than linear 1
formula for last day of month with a twist 5
Excel repatation of Formula 8
Trailing 30 days sum calculation with excel 1
First day and Last day of the month to display automatically 1
Excel - in a row of numbers, put last entered number Cell B2 7
Last day of last month 5

Back
Top