Cheers, I'll give it a go
Bob

"Bob Phillips" wrote in message
...
Use a formula of

=D2+CHOOSE(WEEKDAY(TODAY()),1,0,6,5,4,3,2)

for the Monday date, and just add 1 to that for Tues, etc.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Nospam" wrote in message
...
I would appreciate a bit of help if possible
My itinerary works but only on a Sunday update, the dates above the days
of
the week will be wrong otherwise.
Have studied "Workday" function, but am not sure where to go.......... no
comments please !!

How can this be done so that if the sheet is updated on a Friday of the
previous week, or maybe Saturday, it still reads right for the following
Monday etc.
Regards
bob