With a date in A1, the formula below will compute the date of the following
Monday
=A1+(WEEKDAY(A1)1)*(9-WEEKDAY(A1))+(WEEKDAY(A1)=1)
Remember to format as date
Replacing A1 by TODAY() we get
=TODAY()+(WEEKDAY(TODAY())1)*(9-WEEKDAY(TODAY()))+(WEEKDAY(TODAY())=1)
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Savio" wrote in message
...
is there any way to have a cell in excel update itself every week to
show the first day of the following week?

thanks