Formula Auto Dates

[Adrac]

Hello all,

A simple one for you.

I would like a auto row to show months of the year in his order
Cell B7: last month "August" Cell B8: This month Cell B9: Next month ..... and so on, so I have 13 months in total.

Is there a formula like =TEXT((MONTH),"mmmm")+1 ... +2..... +3 etc

Thanks

Adrac

 

[bbott]

Do you want the months to change (i.e. B7 will always be last month, not always August)?

 

[Adrac]

Hello Bbott

yes, this will change as the rest will depending on current month this was to demonstrate the format. just need month not full date.

 

[Snakehips]

Adrac,

Perhaps in B7 and drag down....


=TEXT(EOMONTH(TODAY(),ROW()-8),"mmmm")

Hope that helps.

 

[Adrac]

Ok that works, however not sure how, can you explain the break down. Also found a flaw in my own question lol:

Can you also add I year like "August 14" as there are 2 of the same month.

Adrac

 

[bbott]

To add the year:

=TEXT(EOMONTH(TODAY(),ROW()-8),"mmmm yy")

 

[Adrac]

Great thank you, your a star!