How to automatically list months preceding a certain month
Hi All, I hope someone can assist me please. I have a cell which reads a variable from another cell. This variable can be any month in the year. I would like to have the 11 months preceding this specific month listed depending on the set variable. How can I do this, as I cannot find anything on this formula? Or do I need a VBA? Any help would be appreciated.
Maybe something like this will work. The date that is calculated is in C1 and this formula I entered in E1 and filled down:
Formula:
Please Login or Register to view this content.
This will also work.
Enter this in E1
Formula:Please Login or Register to view this content.
Enter this in E2 and fill down:
Formula:Please Login or Register to view this content.
Last edited by newdoverman; 05-09-2015 at 07:27 PM.
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
Is this a date? A month name (text string) like Feb? A month number?Originally Posted by ramatthews
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
Hi Tony,
This will be in the format of a month name i.e. Feb 2015. Thanks for the assistance.
Maybe this...
Data Range
A1 = some date in Feb 2015 formatted to display as mmm yyyy
This formula entered in A2 and copied down to A12:
=EDATE(A$1,-ROWS(A$2:A2))
Apply the same format: mmm yyyy
Here are a couple of ways to solve this to add to your collection. These are similar to my first post but arranged differently for simplicity.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks