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
 

Excel Facts

Move date out one month or year
Use =EDATE(A2,1) for one month later. Use EDATE(A2,12) for one year later.

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,550
Office Version
  1. 365
  2. 2010
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")
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,163,598
Messages
5,832,646
Members
430,150
Latest member
amitk1

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top