Conditional + date calculation

[rvelez]

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,

 

[crferguson]

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