Business days between booking and departure
Column A holds the booking date, column B the flight departure date for one AirAsia reservation. Write a formula in C1 that returns the number of weekday (business) days between the two dates, counting both the booking date and the departure date.
Starting grid
| A | B | C | |
|---|---|---|---|
| 1 | 2026-01-05 | 2026-01-20 |
Basic
The expected output and walkthrough for this question unlock with a Basic plan.
Basic
The reference formulas and walkthrough for this question unlock with a Basic plan.
Basic
This is a Basic question
Premium practice questions unlock with a Basic plan. The full solution, expected output, and grading are available to Basic members.
RM 25/mo · cancel anytime