What this category helps you do
Date and time formulas are useful for schedules, invoices, project trackers, HR records, subscription reports, and monthly dashboards. They help convert calendar logic into repeatable calculations.
- Calculate days between two dates
- Find the end of a month
- Count working days excluding weekends
- Create due dates and renewal dates
Date & Time formula examples
Choose a formula below. Each page explains the formula in plain English and gives examples one at a time so long formulas are easier to read and copy.
Convert Text Dates
converts dates stored as text into real Excel dates that can be sorted and calculated.
Open examples →FormulaDATE
creates a real Excel date from separate year, month, and day numbers.
Open examples →FormulaDATEDIF
calculates the difference between two dates in years, months, or days.
Open examples →FormulaDAY
returns the day of the month from a date.
Open examples →FormulaEDATE
returns a date a specific number of months before or after a start date.
Open examples →FormulaEOMONTH
returns the last day of the month a set number of months before or after a date.
Open examples →FormulaHOUR
returns the hour from a time value.
Open examples →FormulaMINUTE
returns the minute from a time value.
Open examples →FormulaMONTH
returns the month number from a date.
Open examples →FormulaNETWORKDAYS
counts working days between two dates, excluding weekends and optional holidays.
Open examples →FormulaNOW
returns the current date and time.
Open examples →FormulaSECOND
returns the second from a time value.
Open examples →FormulaTIME
creates a real Excel time value from hour, minute, and second numbers.
Open examples →FormulaTODAY
returns the current date and updates when the workbook recalculates.
Open examples →FormulaWEEKDAY
returns the day of week as a number.
Open examples →FormulaWEEKNUM
returns the week number for a date.
Open examples →FormulaWORKDAY
returns a date after a number of working days, excluding weekends and optional holidays.
Open examples →FormulaYEAR
returns the year from a date.
Open examples →FormulaYEARFRAC
returns the fraction of a year between two dates.
Open examples →Best formulas to start with
How to learn this category
- Open one formula page and test the first beginner example.
- Change one cell reference at a time so you understand what each part controls.
- Check the common mistakes section before copying the formula down.
- Move to related formulas when you need a cleaner or more advanced version.