Bob,

Posting attachments to the NG is discouraged and most people will not open
them for fear of viruses or other nasties so ....... wiithout looking at
your spreadsheet and guessing that the dates and days are not linked - thus
only corrct for one day of the week - try entering the name of the day by
formula instead of directly as in:

=Text(DateCell,"dddd")

which will print the right day for that date.

HTH

Sandy

--
to e-mail direct replace @mailinator.com with @tiscali.co.uk


"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