Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Conditional + date calculation
Hi,
I deal with cases on daily basis and have a business rule that if the case is received before 3pm the case has 48 hrs (2 business days) to be completed but if it is received after 3 pm the case has 72 hrs (3 business days). How can I calculate this? Ex. Cell A1 has date 3/28/2008 3:06:36 PM The due date in cell B2 should be 4/2/08 3:06:36 PM (should exclude sat,sun, and federal holidays) Thank you in advance, |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Conditional + date calculation
On Apr 10, 8:13*am, rvelez wrote:
Hi, I deal with cases on daily basis and have a business rule that if the case is received before 3pm the case has 48 hrs (2 business days) to be completed but if it is received after 3 pm the case has 72 hrs (3 business days). How can I calculate this? Ex. Cell A1 has date 3/28/2008 3:06:36 PM The due date in cell B2 should be 4/2/08 3:06:36 PM (should exclude sat,sun, and federal holidays) Thank you in advance, This would be fairly simple... until the monkey wrench of excluding federal holidays :-) Unless someone else knows a better way of doing it, I think you'd have to set up special conditions to check for those dates and then skip them if they fall within the two/three day range you're speaking of. For date calculations in Excel, my best advice is to read what Chip Pearson, Excel guru, has to say about them. He can explain it much better than I could: http://www.cpearson.com/excel/DateTimeWS.htm Hope that helps, Cory |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Date Calculation & Conditional Formatting | Excel Discussion (Misc queries) | |||
Date Calculation in Conditional Formatting | Excel Worksheet Functions | |||
End Date Calculation (adding a start date duration) | Excel Discussion (Misc queries) | |||
Tricky Date calculation: How to calculate a future date | Excel Discussion (Misc queries) | |||
Coding to show first _weekday_ prior to a date, when date calculation happens to fall on weekend? | Excel Programming |