Formula hub · Updated May 13, 2026

Date & Time

Calculate workdays, date gaps, due dates, month ends, and spreadsheet-friendly date values.

Guides in this category

DATEDIF Examples

Use DATEDIF to calculate years, months, or days between two dates.

WORKDAY Formula

Use WORKDAY to calculate a date after a number of working days.

Add Business Days to a Date

Add working days to a start date while skipping weekends and optional holidays.

Calculate Age from Date of Birth

Calculate age in years from a birth date using DATEDIF in Excel or Google Sheets.

Days Until a Date

Calculate how many days remain until a deadline, event, or due date.

Get Month Name from a Date

Convert a date into a month name or month label in Excel or Google Sheets.

NETWORKDAYS Formula

Use NETWORKDAYS to count working days between two dates.

Get Week Number from a Date

Convert a date into a week number for weekly spreadsheet reports.

Combine Date and Time in Excel or Google Sheets

Combine separate date and time columns into one timestamp value.

How to choose a formula

Start from the spreadsheet task, then choose the simplest formula that gives a maintainable answer. A report that someone else must update next month often needs clarity more than cleverness.