| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
just weekdays
dear Bob
can you explain that a little bit more ps? No need to check for Sunday, the Saturday check will skip it =C2+1+(WEEKDAY(C2)=6)*2 -- HTH Bob Phillips (replace xxxx in the email address with gmail if mailing direct) "peter the swede" wrote in message oups.com... Hi all on a spreedsheet I´ve a series with dates, where from previous date 1 day is added (i.e. C3=C2+1). Now I wan´t to do the following: 1) check if C10 is a saturday? 2) if C10 is saturday than go to monday 3) check if C10 is sunday ? 4) if yes then add 1 day 5) if C10 is not sunday, than add 1 day I hope you understand what I want to do Thanks in advance //Peter |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| SUM/ Count Only weekdays | Excel Worksheet Functions | |||
| Weekdays | Excel Discussion (Misc queries) | |||
| Weekdays only! | Excel Discussion (Misc queries) | |||
| Weekdays | Excel Discussion (Misc queries) | |||
| calculate weekdays only | Excel Programming | |||
Threaded Mode
