Need help with a date formula

  • Thread starter Andrew Mackenzie
  • Start date
A

Andrew Mackenzie

Hi Folks,

I would really appreciate help with this.

I need a formula for the date that is the last day of the month three months
ago. E.g. if today is 28th Feb 2009, I want to return 30th Nov 2008. So
maybe someone could construct the formula for me with 28th Feb 2009 in cell
A1.

Many thanks, probably a lot easier than it seems to me right now.

Andrew
 
M

Mike H

Hi,

=eomonth(TODAY(),-3)

If you get a #NAME error then

Tools|Addins - Select the analysis toolpak
Re-Enter the formula

Mike
 
M

Mike H

In case you don't have the analysis toolpak

=DATE(YEAR(TODAY()), MONTH(TODAY())-2, 0)

Mike
 

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

Find the position of a date 6
counting dates before today 1
Date Calculation 4
Pivot Table Formulas 0
Need help with a formula... 5
Help showing active months between two dates 5
Need help with Calculation 5
Use Workbook tabs in a Worksheet 1

Top