Updevly
Main content

Excel date formulas

Date and workday formulas you can paste.

Pick the job, enter cells or dates, and copy a US-English Excel formula for NETWORKDAYS, WORKDAY, EOMONTH, EDATE, DATEDIF, or YEARFRAC.

Date difference guide

Dates

10 free today

Count weekdays between two dates. Weekends are skipped; holidays are optional.

Leave blank if you only need weekends skipped

The paste-ready formula below is built from your ranges. Generate with AI when you need a variant, IFERROR, or NETWORKDAYS.INTL.

D2

=NETWORKDAYS(A2,B2,$H$2:$H$20)

NETWORKDAYS counts weekdays from A2 through B2, including both ends when they are workdays, and skips dates in $H$2:$H$20.

Built from your ranges

  • Keep the holiday range as dates, not text.
  • Both the start and end dates count when they fall on a workday.

Examples

A workshop, not a function list

The six functions cover the usual date jobs: working days between two dates, a due date n workdays out, month-end close, the same day n months later, completed age or tenure, and a year fraction for interest. Fill the ranges on this page. Generate with AI when you need a holiday sheet, a weekend convention, or an error guard.

What to put in the cells

  • Use cell references such as A2 and B2, DATE(2026,1,15), or TODAY().
  • Put company holidays in a dedicated range and lock it with $ if you will copy the formula down.
  • Format NETWORKDAYS and DATEDIF results as General or Number so they do not display as dates.
  • Format EOMONTH, EDATE, and WORKDAY results as dates.

Date formula FAQ

When should I use NETWORKDAYS instead of subtracting two dates?

Subtracting dates counts every calendar day. NETWORKDAYS counts weekdays and can skip a holiday range. Use it for SLAs, project duration, and payroll calendars.

What is the difference between EOMONTH and EDATE?

EOMONTH always returns the last day of a month. EDATE keeps the same calendar day and moves by whole months, falling back to the last valid day when needed.

How do I calculate age in years?

Choose Age in years, point the start date at the birth date cell, and use TODAY() as the end date. The workshop writes DATEDIF with unit "y" for completed years.

Does Generate with AI replace the formula on the page?

The workshop first builds a formula from your ranges. Generate with AI sends that job through the same Excel generator, so you can add IFERROR, NETWORKDAYS.INTL, or other notes without leaving the page.