LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Loyalise
 
Posts: n/a
Default Calculating due date?


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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Date updates from worksheet to chart & changes date to a date series! Help!! Jayjg Charts and Charting in Excel 2 January 22nd 05 03:00 PM
Date issue between Windows and Macintosh version dlg1967 Excel Discussion (Misc queries) 4 January 19th 05 03:51 PM
Calculating Date difference in 2 ways Hari Excel Discussion (Misc queries) 5 January 15th 05 10:25 PM
Date Formula Robyn Bellanger Excel Discussion (Misc queries) 2 December 17th 04 07:25 PM
Addition to Turn cell red if today is greater or equal to date in cell Rich New Users to Excel 2 December 9th 04 02:06 AM


All times are GMT +1. The time now is 06:36 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"