I have a spreadsheet that is used to calculate a due date 90 days from
the current date. My problem is I need to have the system look at the
due date and if it falls on a weekend or holiday to push the due date
to the next weekday (or business day). ALSO, can I hide the cell where
the calculation is performed and have it place the correct due date
(business day date) in a cell where it will show and be printed on the
statement.
I'm a novice Excel user -- can do most "easy" functions -- but this one
has me stumped.
Any help would be greatly appreciated!
--
Loyalise
------------------------------------------------------------------------
Loyalise's Profile:
http://www.excelforum.com/member.php...o&userid=15966
View this thread:
http://www.excelforum.com/showthread...hreadid=274414