Yes, MacBook Air runs Excel — but only if you install Microsoft 365 or buy it separately. But macOS doesn’t ship with Excel preinstalled, and the free ‘Excel for iCloud’ has real limits when you’re editing payroll data offline.
The Setup
You’re managing vendor payments for a small logistics firm. Eight vendors, each with invoice date, amount due, payment status, and contract renewal date. You need to flag overdue invoices, calculate days past due, and sort by urgency — all on your MacBook Air while traveling.
Vendor
Invoice Date
Amount Due
Status
Renewal Date
SwiftHaul Logistics
2024-02-18
$12,450
Paid
2024-08-31
Nexus Freight Co.
2024-01-30
$8,920
Overdue
2024-07-15
Alpine Dispatch
2024-03-05
$6,310
Pending
2024-10-22
TerraRoute Services
2023-12-11
$15,670
Overdue
2024-05-10
VistaLoad Inc.
2024-02-29
$4,180
Pending
2024-09-05
Orion Transit Group
2024-01-14
$9,250
Overdue
2024-06-30
Coastal Haulers LLC
2024-03-12
$7,430
Pending
2024-11-18
Summit Fleet Partners
2023-11-27
$11,890
Overdue
2024-04-14
The Challenge
You need to calculate days past due in column E using =TODAY()-B2 — but TODAY() returns the Mac system date, and if your MacBook Air is set to GMT+8 while your invoices are dated in PST, Excel silently misaligns the calculation. Also, sorting by 'Overdue' status fails because some entries say 'overdue', others 'OVERDUE', and one says 'late'. No auto-filter works until you fix case inconsistency — and that’s not obvious unless you select B2:E9 and press Alt+D, S to open Sort dialog, then check 'Case sensitive'.
The biggest trap? Assuming Excel for iCloud (which opens when you click a .xlsx file in Safari) lets you use XLOOKUP or dynamic arrays. It doesn’t. Those formulas return #NAME? — and there’s no error tooltip. You just see red.
Walking Through It
Start with A1:E9 selected.
Step 1: Clean status text. In F2, enter =PROPER(D2). Drag down to F9. Now 'OVERDUE' becomes 'Overdue', 'late' becomes 'Late'. Copy F2:F9 → Paste Values over D2:D9. Delete column F.
Before:
D2:D9
Paid
Overdue
Pending
Overdue
Pending
OVERDUE
Pending
late
After:
D2:D9
Paid
Overdue
Pending
Overdue
Pending
Overdue
Pending
Late
Step 2: Add Days Past Due in E2. Use =IF(D2="Overdue",TODAY()-B2,"-"). Drag to E9. Don’t use =TODAY()-B2 alone — that gives negative numbers for future-dated renewals, which breaks sorting logic.
Step 3: Sort correctly. Select A1:E9 → Alt+D, S → Sort by Column D → Order: 'Overdue' first, then 'Late', then 'Pending', then 'Paid'. Uncheck 'My data has headers' if your selection includes row 1 — otherwise Excel treats 'Vendor' as data and shifts it down.
The Result
Final table, sorted by urgency and cleaned:
Vendor
Invoice Date
Amount Due
Status
Days Past Due
TerraRoute Services
2023-12-11
$15,670
Overdue
101
Summit Fleet Partners
2023-11-27
$11,890
Overdue
116
Nexus Freight Co.
2024-01-30
$8,920
Overdue
62
Orion Transit Group
2024-01-14
$9,250
Overdue
78
Alpine Dispatch
2024-03-05
$6,310
Pending
-
VistaLoad Inc.
2024-02-29
$4,180
Pending
-
Coastal Haulers LLC
2024-03-12
$7,430
Pending
-
SwiftHaul Logistics
2024-02-18
$12,450
Paid
-
What Could Go Wrong
Mistake #1: Opening the file in Numbers instead of Excel. macOS defaults .xlsx files to Numbers. You’ll see formulas like =TODAY()-B2 display as plain text — not calculated. Fix: Right-click file → Get Info → Open With → Microsoft Excel → Change All.
Mistake #2: Using Excel for iCloud from a shared link. You’ll edit online, save, close — then reopen and find all formatting gone, column widths reset, and conditional formatting stripped. That’s because Excel for iCloud ignores most desktop formatting rules.
Mistake #3: Installing Excel via Homebrew or third-party store. Some Mac package managers pull outdated ARM builds without Apple Silicon optimization. You’ll get constant beachballing on large ranges. Only install from microsoft.com or the Mac App Store.
Here’s what to do next:
Action
How
Time
Install Excel
Go to office.com → Sign in → Install Office → Run pkg
3 min
Set default app
Right-click any .xlsx → Get Info → Open With → Excel → Change All
45 sec
Verify version
Excel → About Excel → Must show 'Version 16.x' and 'ARM64'
20 sec
Rachel Torres
Rachel coaches teams on email management and digital communication best practices. She has trained over 5
