Hi Everyone,
Attached is a excel file test auto month.xlsx which I'm trying to set up a sheet that will populate the next 12 months based on the first column being the month we are up to. I've tried 2 separate methods however i'm encountering difficulties. I want it to be a formula based rather than VBA. Please see the 2 ways used in the sheet.
I would appreciate if someone can help me.
Thanks
rosboy,
Without using the 'Month Names' sheet helper table, in cell A2 and copy right:
[EDIT]:
Please Login or Register to view this content.
Alternate formula
[EDIT 2]:Please Login or Register to view this content.
Noticed you are using date values with a custom format of mmmm already, in which case you can simply drop the Text() function out of the suggested formulas:
Please Login or Register to view this content.Please Login or Register to view this content.
Last edited by tigeravatar; 11-01-2012 at 05:07 PM. Reason: Added alternate formula, added note about the Text() function
Hope that helps,
~tigeravatar
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Thanks alot for the quick solution. major improvement over my long formula!
You're very welcome
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks