Loading the Toolpak

http://office.microsoft.com/en-us/as...277241033.aspx

http://www.cpearson.com/excel/ATP.htm

Regards

Trevor


"peter the swede" wrote in message
oups.com...
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