following week
 

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

thanks

following week
 

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

following week
 

What day is the first day of the following week... Sunday or Monday? Also,
what do you want to show if the date IS the first day of the week... itself
or the first day of the next week?

--
Rick (MVP - Excel)


"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