Subtract 1, 2 and 3 months from the text "September"
On Oct 13, 1:57*pm, Sean Timmons
wrote:
then, may as wel make A1 as TODAY() and format cells, custom, mmmm
then B1 would be =DATE(year(A1),month(a1)-1,Day(A1))
And C1 would be =DATE(year(A1),month(a1)-2,Day(A1))
etc.
and this will also work for January counting back to December...
"wx4usa" wrote:
I have column A with the text string "September" and I need to have
column B show "September" minus 1 month or "August". Column C "July"
and D "June"
Then next month column A will change to October and B,C&D will move up
a month.
Make sense???
Thanks in advance for your help.
I have column A with the Month September. Then column B needs to say
August, Then June so I can use these columns in a sumproduct formula
for the last 3 months sales. I dont want to have to go in and type
the other 2 months in because someone else will be doing entry.
|