Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
just weekdays
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 |