Calculating due date?

[Loyalise]

I have a spreadsheet that is used to calculate a due date 90 days fro
the current date. My problem is I need to have the system look at th
due date and if it falls on a weekend or holiday to push the due dat
to the next weekday (or business day). ALSO, can I hide the cell wher
the calculation is performed and have it place the correct due dat
(business day date) in a cell where it will show and be printed on th
statement.

I'm a novice Excel user -- can do most "easy" functions -- but this on
has me stumped.

Any help would be greatly appreciated! :confused

 

[Peo Sjoblom]

Use WORKDAY

if you get a name error you need to install ATP (Analysis ToolPak) under
tools>add-inns, check ATP and keep the office/excel CD handy and follow the
instructions

=WORKDAY(date,90,holidays)

=WORKDAY(A1,90,H2:H12)

where A1 holds the date, 90 is 90 days and holidays is a range with all the
public holidays)

--
Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)

 

[Guest]

You may try the following.
Find the dates of holidays within the next 90 days & give serial numbers for
these dates.You can give conditional (if a particular date is a holiday,show
date <>"That date")
Example:=if(or(a10="11/11/2004",a13="11/14/2004",...),1,0)-to add 1 more day
for the number of days,for each holiday in between.Please try & advise.