You will use the Nested IF function to identify orders that are late in payment and calculate with dates in Excel.

LATE PAYMENT ANALYSIS Today's date: 4/29/2017 Days Out Status Order # AZ-234 MW-945 PA-216 Customer Amount Accounting Major $ 144.25 Finance Major $ 215.44 Management Major $ 322.05 Marketing Major $ 255.90 Date Sent 3/27/2017 1/23/2017 4/24/2017 2/26/2017 DR-340