Grüezi DangerMouse114

DangerMouse114 schrieb am 07.06.2004

I was wondering what I would have to do to be able to make a macro that
would take the a list of sundays (lets say ten) bring the most recent
five to the top of the list then auto fill the next five sundays(with
their dates) in the five cells that are now open under them.

In A1 copy the following formula (with VBA, if you like)

=TODAY()-35-WEEKDAY(TODAY(),2)

In A2 copy the following and autofill as far as you like with the
autofillhandle in the bottom right corner of the cell;

=A1+7

--
Regards

Thomas Ramel
- MVP for Microsoft-Excel -

[Win XP Pro SP-1 / xl2000 SP-3]