Almost got it !! but need advice
 

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

1. You attached a workbook which is a NO NO here.
2. You need to use meaningful subject lines for other in the archives.
3. You need to state your question in a sensible way so that all can
understand. No mind readers around here.
Care to try again?

--
Don Guillett
SalesAid Software

"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

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

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

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

Hi,

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

Or

=D2+7-WEEKDAY(TODAY()+5)

Daniel M.

P.S.: I haven't look at the file and don't know what the OP wants. This is
solely another brick in my unrelentless cursade (!) against the illogical
CHOOSE(WEEKDAY()) formula construction ;-))

Funny, I thought it was you I pinched it from :-)

Bob


"Daniel.M" wrote in message
...
Hi,

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

Or

=D2+7-WEEKDAY(TODAY()+5)

Daniel M.

P.S.: I haven't look at the file and don't know what the OP wants. This is
solely another brick in my unrelentless cursade (!) against the illogical
CHOOSE(WEEKDAY()) formula construction ;-))