MrExcel Publishing
Your One Stop for Excel Tips & Solutions

MONTH HEADING


Posted by HARISH SHELAT on September 12, 2000 5:16 AM


I like to put the current month heading accoding
to cuurrent month + next 11 month in worksheet
col heading. How can i do this?

Thanks


Posted by Celia on September 12, 0100 6:17 AM


Harish

Format cells A1:L1 as "mmmm".

Put in A1 :-
=NOW()

In B1 put :-
=EDATE(A1,1)
Fill this formula across C1:L1

The second formula will only work when the Analysis Toolpak add-in is installed.

Celia