Previous month based on current month

[spectraflame]

I am using the following formula to return the current month.

=TEXT(TODAY(),"MMMM")

However I would like to return the previous month. I know that if it were the year, I can just add -1 to the end of the formula, but that returns #VALUE when tried with the MMMM format.

Thanks,
Matthew

 

[CDRToast]

Very interesting thread,
Just had this come up in the office... and My coworker and I came up with the same solution Aladin did.
We did have a different solution to the one presented by Suavis for the "two months ago" scenario.

=TODAY()-DAY(TODAY())-DAY(TODAY()-DAY(TODAY()))

While not efficient if you had numerous places you had to use it, it's a pretty effective way to get the month before last month.

 

[Scott Huish]

You could also just use EOMONTH:

=EOMONTH(TODAY(),-2)

This has been included as a standard function since XL2007.

 

[Sean15]

A1: =TODAY()
B1:B10000: =TEXT($A$1-DAY($A$1),"MMMM")

In this scenario, Today is only calculated once in A1
Then you have 10000 cells referring to A1.

Hello:

Excel says the formula below has an error. Could you help me fix it?

="DEDUCT deposits made in TEXT($F$1-DAY($F$1),mmmm") but recorded in QB in "&TEXT(F1,"mmmm")

F1=02/18/16

so the formula should return DEDUCT deposits made in Jan but recorded in QB in Feb

Thanks or your help

Sean

 

[FDibbins]

Looks like youy have some "" in the wrong places...
="DEDUCT deposits made in "&TEXT($F$1-DAY($F$1),mmmm")&" but recorded in QB in "&TEXT(F1,"mmmm")

 

[Sean15]

Looks like youy have some "" in the wrong places...
="DEDUCT deposits made in "&TEXT($F$1-DAY($F$1),mmmm")&" but recorded in QB in "&TEXT(F1,"mmmm")

Excellent with one small change per Excel correction:

="DEDUCT deposits made in "&TEXT($F$1-DAY($F$1),"mmmm")&" but recorded in QB in "&TEXT(F1,"mmmm")

The 1st ,mmmm" should be ,"mmmm"


Thank you so very much

Sean

 

[FDibbins]

ooops sorry, left off that ", but you picked it up - great

 

[aspmottta]

Clever!

Thanks

Another alternative...

=TEXT(TODAY()-DAY(TODAY()),"MMMM")

 

[rfigueroa1976]

Bringing up an old subject that I'm hoping you all can help with... I need to display "Current Month" If the date in a cell is in the current month of need to display "Previous Month" if the date in a cell is in the previous month, else, make the cell blank.

The formulate i have at the moment is =if(month(today()-1=month(today(Y2)), "Previous Month", if(month(today()=month(today(Y2)), "Current Month", ""))))

Obviously, it's not working. Please help!

 

[Scott Huish]

=IF(MONTH(Y2)=MONTH(TODAY()),"Current Month",IF(MONTH(Y2)=MONTH(EOMONTH(TODAY(),-1)),"Previous Month",""))

 

[rfigueroa1976]

This partially gets me there.

Because the data includes several years, the result of the above formula is that both, December if 2018 and December of 2017 are being counted as "Previous Month" and the same goes for Current Month.

I tried the following but, no go...

=IF(and(year(Y2), MONTH(Y2))= and(year(today(), MONTH(TODAY()),"Current Month", IF(and(year(Y2), MONTH(Y2))= and(year(today(), MONTH(EOMONTH(TODAY(),-1)),"Previous Month",""))))))