Calendar diff vs raw totals
'2 years 3 months 14 days' is what you'd say in conversation. '839 days' is what a spreadsheet computes. Both are correct — they answer different questions.
- Calendar diff respects variable-length months and leap years. Useful for age, tenure, lease term.
- Total days ignores calendar structure. Useful for billing, SLA reporting, project planning.
- Business days excludes Saturdays and Sundays. Note: doesn't account for holidays.