Date count formula.

Hello All:

I have cell A for Date Order, cell B for Date packaging, cell C for Date Shipping. I would appreciate your help with the formula for:
1. Cell B is 4 working days from Date Order.
2. Cell C is 8 calendar days from Date Order.

Thanks in advance!
KT

A2 contains a date.
B2 =IF($A2>0, $A2+4, "") ...formatted as a date
C2 =IF($A2>0, $A2+8, "") ...formatted as a date


Copy the B2 and C2 formulas down as far as you want. The formulas will only generate dates when you put a date into column A.

For B you would be best advised to use the WORKDAY function - prior to XL2007 this requires activation of the Analysis ToolPak Add-In via Tools -> Add-Ins
(there are alternatives but they can be cumbersome pending public holiday requirements)

B2: =IF(A2,WORKDAY(A2,4,holidayrange),"")
copied down

that in red is optional but essentially refers to a named range that would contain a listing of public holidays should they be needed

If that takes care of your need, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.

For the sake of my sanity (and future readers) when you say:

Originally Posted by 11ktran44

Cell B is 4 working days from Date Order.

do you actually mean working days or are you in fact referring to just calendar days ?

for the former post # 2, for the latter post #3