Todays date minus 1 month

[Newton1234]

Hi,

I am trying to write a formula which takes todays date and goes back 1 month.

Eg Today = 20/11/2008, however my formula would give me 20/10/2008

I have tried

=Today()-1

However this just minuses a day.

Any help is appreciated.

Thanks

[NBVC]

Try:

=Date(Year(Today()),Month(Today())-1,Day(Today())

[Newton1234]

That is great thanks.

Would it be possible to just pick out the month ? Eg, if I am doing todays date minus one month, it would bring back 10 (or October) ?

Thanks

[NBVC]

To get just the number 10 for October... you can just use =Month(Today())-1

To get the month name...

=Text(Date(Year(Today()),Month(Today())-1,Day(Today()),"MMMM")

[Newton1234]

Thanks, it might be a little easier to have the word of the month, however the formula gives me an error of too many arguments and highlights the end "MMMM" part.

Your help is really appreciated.

[dominicb]

Good afternoon Newton1234

You could invoke the Analysis ToolPak add-in (Tools > Add-ins) and use this formula :
=EDATE(NOW(),-1)

The just format your cell using custome format to MMMM (or MMM for abbreviated months).

HTH

DominicB

[Newton1234]

Hi, thanks for your help.

I have tried this but I just get an error of #Name?

I selected a custom format for the cell of MMMM.

Any help would be fab.

[NBVC]

Thanks, it might be a little easier to have the word of the month, however the formula gives me an error of too many arguments and highlights the end "MMMM" part.

Your help is really appreciated.

Forgot a parenthis...

=TEXT(DATE(YEAR(TODAY()),MONTH(TODAY())-1,DAY(TODAY())),"MMMM")

As for Dominic's formula, you need to install the Analysis Toolpak.. throught Tools|Addins

[Newton1234]

Thank you very much, that has worked great :-)

Much appreciated