Not sure what you mean by "and so on depending on current month". I
assume that B1 has the current month and you want C1 to automatically
update to the next month based on the value in B1. Use the EDATE
function in C1.

=EDATE(B1,1)

If you are looking for a function to return todays month in B1 so each
month it changes then you could use =NOW() or =TODAY() in B1. Format
as mmmm to see the date in text (January, February etc...).

Then use the EDATE in C1. B1 and C1 will update with the change of
each month using these. You can copy the EDATE function across row 1
for the desired number of months.

I believe you need to install the Analysis Toolpak to use the EDATE
function. To do that, go to the Tools Menu, Add-ins, click on the
Analysis Toolpak check box and click on OK. This will run the
install.

Does that help?

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=534170