What days do you want to show and when should they change?

You could adapt something like this

A1

=TODAY()+7-WEEKDAY(TODAY()-2)

A2

=A1+7

copied down to A4

A1:A4 now shows the next four Mondays (including today if a Monday),
it'll change on a Tuesday


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=513826