Hello all,
I have been asked to build a spreadsheet at work to track orders. I am able to build most of it but an stumped on a few formulas.

Any help is appreciated!

Scenario A: Need Age to calculate NETWORKDAYS if 3 conditions are met.
1. If units are less than or equal to 99 for the first Age, greater than or equal to 100 for the second age.
2. If no date in column B or D, result to be left blank
3. If column B has date of "00/00/00" result in age of 0 days

Scenario B: Need 3 formulas in this scenario:
1. Calculate for each customer how many days behind an order is based on it's order date and it's goal date. If it's within goal date range, return "Current", otherwise result in number of days behind the order is.
2. Calculate for each customer it's oldest date order based on units
3. Calculate the overall oldest order date

EXAMPLE 2.22.24.xlsx