Consecutive Date List

[turist]

I want to make a Consecutive Dates List, starting from any day with a formula.

Attached file defined detail and what is wanted.

Thanks in advance for any reply and help.

Regards,
turist

[Fotis1991]

Hi

The auto fill option(the + sign in the bottom right of the cell), when you fill down gives you the option to fill with months!

http://www.youtube.com/watch?v=zDn-Fttk4cU

[turist]

Hi

The auto fill option(the + sign in the bottom right of the cell), when you fill down gives you the option to fill with months!

http://www.youtube.com/watch?v=zDn-Fttk4cU

Dear Fotis1991
Thanks for prompt reply and info.
I know this method, but First date (Beginning day) comes another file and contains a formula.
In that case Auto fill (to fill with months) does NOT work.
Therefore, I need a formula to solve this issue.

Regards,
turist

[popipipo]

=EDATE(B$2;$A3-1)
Try this formula in B3 and puldown and right.

[turist]

=EDATE(B$2;$A3-1)
Try this formula in B3 and puldown and right.

Dear popipipo,
Thanks a lot .(I learnt a new function)

Regards,
turist

[newdoverman]

For column B perhaps this will satisfy the conditions for all columns. Enter in B3 and copy across and down.

Please Login or Register  to view this content.

[turist]

For column B perhaps this will satisfy the conditions for all columns. Enter in B3 and copy across and down.

Please Login or Register  to view this content.

Thanks for reply, but your formula does not fit for all columns.

I found this formula:

Please Login or Register  to view this content.

It worka for all conditions correctly.

Regards,
turist