mgm05267
12-26-2011, 10:40 AM
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
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