Hi All,
I am new this board and relatively new to Excel - I was brought up on 1-2-3 (not by choice, a corporate decision by my employers).
Anyway, most things I can figure out but I am currently stuck with this slight problem.
I am developing a sheet that contains statistical data for a period of twelve months, back from from toda. I want to create a row of 12 cells showing the mmm/yy labels for each month/year of the last twelve months.
Is there a way to show a label for the current month, based on the current time/date settings, then for labels to the left of this cell to decrease incrementally for the twelve months period?
Hope I have made this clear.
Thanks
Dave
I am new this board and relatively new to Excel - I was brought up on 1-2-3 (not by choice, a corporate decision by my employers).
Anyway, most things I can figure out but I am currently stuck with this slight problem.
I am developing a sheet that contains statistical data for a period of twelve months, back from from toda. I want to create a row of 12 cells showing the mmm/yy labels for each month/year of the last twelve months.
Is there a way to show a label for the current month, based on the current time/date settings, then for labels to the left of this cell to decrease incrementally for the twelve months period?
Hope I have made this clear.
Thanks
Dave