Home |
Search |
Today's Posts |
|
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
#5
|
|||
|
|||
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 |
#6
|
|||
|
|||
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 ;-)) |
#7
|
|||
|
|||
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 ;-)) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Advice please | New Users to Excel | |||
advice needed | Excel Worksheet Functions | |||
Advice needed... | Excel Discussion (Misc queries) | |||
building invoice - strategy advice | Excel Discussion (Misc queries) | |||
need an advice in excel sheets.... | Excel Discussion (Misc queries) |