Auto-filled date

[Dewdrop]

Hi Friends,

I'm using Excel 2013. I have a cell to fill up a date. This date will be link to another cell which I need to auto-filled the rest of the cells with continuous month.

How to do this? (please refer the attached file)

Thank you in advance.

[ImranBhatti]

try this in cell I5 and drag to right.

=EDATE(H5,1)

[ImranBhatti]

try this in cell I5 and drag to right.

=EDATE(H5,1)

[Dewdrop]

Hi excelisfun009, bingo, it's what i'm looking for. Thank you very much.

[ImranBhatti]

Glad to have helped!

If the reply really answers your query ,please mark the thread as solved.