Excel Calendar Help

[saini88]

Hi,

I am trying to edit an excel workbook that has a different sheet for each week. I want to format the workbook so that in each sheet cell A2 says Monday 22nd November, cell 37 says Tuesday 23rd November, A72 says Wednesday 24th November, A107 says Thursday... etc, and am unsure if I can use Autofill to fill dates in non-consecutive cells. IS there a way to do this that I could then run in each sheet???

[teylyn]

In A2, enter the starting date manually.

In A2 put this formula and copy down as far as you require

=IF(MOD((ROW()-2)/35,1)=0,$A$2+((ROW()-2)/35),"")

Format the cells with the date format of your choice.

cheers