FinanceTier 715 minintermediate

Invoice Payment Deadline via WORKDAY

Calculate a payment deadline in business days, without counting weekends as working days.

What you will learn

• Use WORKDAY to add a number of business days to a start date
• Explain why adding calendar days directly counts weekends as if they were working days
• Recognise when a payment-terms deadline must skip weekends

Excel skills

WORKDAY · Date and Time Functions

The task

Each invoice has a payment-terms window in business days. Work out the payment deadline for each one, in column C - the calendar date that many business days after it was issued.

You work in a real spreadsheet in your browser, and your answer is checked against hidden traps the moment you submit.

Try this lesson free