subtracting month

**miners** · 08-27-2009, 10:15 PM

Hi All,

Can anyone help me how to substract a date (month).
e.g i have cell A1 = August. How to get in another cell, i.e B1= July,
which is the month before. (Without using lookup to another database)
Really appreciate your help

Cheers,
Miners

**NBVC** · 08-27-2009, 10:26 PM

Do you have the text "August" or a date formatted to month as mmmm?

if the latter, try =TEXT(DATE(2009,MONTH((H3&" 1, 2009")+0)-1,1),"mmmm") where H3 contains the word "August"...

if the former: =DATE(YEAR(H3),MONTH(H3)-1,1) formatted as mmmm

**miners** · 08-27-2009, 11:30 PM

You're the best NBVC, thanks

**DonkeyOte** · 08-28-2009, 03:02 AM

I know this is resolved, just demo'ing something daddylonglegs showed me which is quite neat, ie this element:

MONTH((A1&" 1, 2009")+0)-1

can be shortened to

MONTH(1&A1)-1

**NBVC** · 08-28-2009, 07:50 AM

Thanks for that DonkeyOte....

I actually never have entered a date as 1August to get 1st August 2009... very neat! Of course, to be expected from the daddy

Thread: subtracting month

Thread Tools

Display

subtracting month

re: subtracting month

Re: subtracting month

Re: subtracting month

Re: subtracting month

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions