Solved: January to December based on Year

[mgm05267]

Hi All.....

I have a query....

In a cell, I will enter year (say "2010")

below this cell I have 12 cells for 12 months

Cells are like this...

1/1/10
2/1/10
3/1/10
...
....
12/1/10

My requirement is like this... If I change the year cell to 2011, the months cell should show like this....

1/1/11
2/1/11
3/1/11
...
....
12/1/11

Please help....

Thanks & Regards,

MGM

[mikerickson]

If you have 2010 in A1, then you could put

=DATE(A1, ROWS($2:2), 1) in A2 and drag downwards.

(Format the cells according to your taste)

[mgm05267]

Hi mikerickson,

Thanks.... its working...

Regards,

MGM