Formula Auto Dates

Adrac

Active Member
Joined
Feb 13, 2014
Messages
272
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
 

Some videos you may like

Excel Facts

Round to nearest half hour?
Use =MROUND(A2,"0:30") to round to nearest half hour. Use =CEILING(A2,"0:30") to round to next half hour.

bbott

Well-known Member
Joined
Feb 5, 2010
Messages
2,350
Do you want the months to change (i.e. B7 will always be last month, not always August)?
 

Adrac

Active Member
Joined
Feb 13, 2014
Messages
272
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

Well-known Member
Joined
May 17, 2009
Messages
5,059
Office Version
  1. 2013
Platform
  1. Windows
Adrac,

Perhaps in B7 and drag down....


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

Hope that helps.
 

Adrac

Active Member
Joined
Feb 13, 2014
Messages
272

ADVERTISEMENT

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

Well-known Member
Joined
Feb 5, 2010
Messages
2,350
To add the year:

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

Watch MrExcel Video

Forum statistics

Threads
1,108,631
Messages
5,523,992
Members
409,554
Latest member
denistrevisan

This Week's Hot Topics

Top