just weekdays
but Trevor, isnīt it so, that WORKDAY isnīt a standard function of
excel?
chears
//Peter
Trevor Shuttleworth skrev:
One way:
=C2+1+IF(WEEKDAY(C2+1)=1,1,0)+IF(WEEKDAY(C2+1)=7,2 ,0)
Or you could use the WORKDAY function
=WORKDAY(C2,1) which gives the flexibility to ignore Bank Holidays, etc
Regards
Trevor
"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
|