Spreadsheet Practice

Excel date functions

Excel stores every date as a number: a count of days in which January 1, 1900 is day 1. That is why you can subtract one date from another, add 30 to get a due date, or sort a column chronologically. Date functions build dates from parts, pull parts back out, and move by months or working days so you don't have to count calendars by hand.

Functions
24
With a graded exercise
All 24
Start with
DATE

Which one should I use?

If you need to…UseWhy
Build a real date from a year, month and dayDATEHandles month and day overflow for you, so DATE(2026,13,1) becomes January 1, 2027.
Add or subtract whole monthsEDATEKeeps the day of the month and clamps to the month's last day when it has to.
Get the last day of a monthEOMONTHThe standard way to find month-end for billing, reporting and due dates.
Count working days between two datesNETWORKDAYSSkips weekends and an optional list of holidays.
Find a deadline a number of working days awayWORKDAYMoves forward or back by business days, skipping weekends and holidays.
Calculate age or tenure in whole yearsDATEDIFCounts complete years, months or days between two dates.

Try DATE live

The most useful date function, on a sample sheet you can edit. Change a value and watch the results update.

  • F2 =DATE(A2,B2,C2) 7/15/2026 Builds July 15, 2026 from three numbers
  • F3 =DATE(A3,B3,C3) 2/1/2027 Month 14 rolls over into February of the next year
  • F4 =DATE(YEAR(E2),MONTH(E2),1) 9/1/2026 First day of the month for the order date in E2

Full DATE guide and practice →

All 24 date functions

FunctionWhat it doesPractice exercise
DATE functionDATE builds a real date from a year, month and day.Build due dates
DATEDIF functionDATEDIF counts the complete years, months or days between two dates.Years and months of service
DATEVALUE functionDATEVALUE converts a date that is stored as text into a real date that Excel can sort, subtract and format.Fix imported dates
DAY functionDAY returns the day of the month from a date, as a number from 1 to 31.Bill due days
DAYS functionDAYS returns the number of days between two dates.Days to pay
EDATE functionEDATE returns the date a given number of months before or after a start date, keeping the same day of the month.Contract end dates
EOMONTH functionEOMONTH returns the last day of the month a number of months before or after a date.Bill at month-end
HOUR functionHOUR returns the hour of a time as a number from 0 to 23, so 1:45 PM gives 13.Hour of each order
ISOWEEKNUM functionISOWEEKNUM returns the ISO 8601 week number of a date: weeks start on Monday, and week 1 is the week that contains the year's first Thursday.ISO week numbers
MINUTE functionMINUTE returns the minutes part of a time as a number from 0 to 59, so 1:45 PM gives 45.Minutes past the hour
MONTH functionMONTH returns the month of a date as a number from 1 to 12.Year and month
NETWORKDAYS functionNETWORKDAYS counts the working days between two dates, Monday to Friday, including both the start and end date.Business days
NETWORKDAYS.INTL functionNETWORKDAYS.INTL counts the working days between two dates, like NETWORKDAYS, but lets you say which days are the weekend: Friday and Saturday, Sunday only, or any pattern written as a seven-character string such as "0000011".Six-day weeks
NOW functionNOW returns the current date and time, and updates whenever the workbook recalculates.Hours since opened
SECOND functionSECOND returns the seconds part of a time as a number from 0 to 59.Seconds of each lap
TIME functionTIME builds a time from hours, minutes and seconds, such as TIME(13,30,0) for 1:30 PM.Finish times
TIMEVALUE functionTIMEVALUE converts a time written as text, such as "1:30 PM" or "13:30", into a real time you can add, subtract and format.Shift lengths from text
TODAY functionTODAY returns the current date, with no time attached, and updates every time the workbook recalculates.Days until due
WEEKDAY functionWEEKDAY returns the day of the week for a date as a number.Number the shift days
WEEKNUM functionWEEKNUM returns the week number of a date in its year, 1 to 54.Week of each order
WORKDAY functionWORKDAY returns the date a given number of working days before or after a start date, skipping weekends and any holidays you list.Ship dates
WORKDAY.INTL functionWORKDAY.INTL returns the date a number of working days before or after a start date, skipping the weekend days you choose and any holidays.Due dates with Sunday off
YEAR functionYEAR returns the four-digit year from a date.Year and month
YEARFRAC functionYEARFRAC returns the fraction of a year between two dates, such as 0.5 for six months.Prorated bonus

Learn them in order

These functions are taught step by step in the Dates track. Each lesson ends with graded exercises on real-looking data.

  1. DATE, YEAR, MONTH & TEXT8 min · Pro
  2. EDATE, EOMONTH & NETWORKDAYS9 min · Pro
  3. Tenure, quarters & weekdays10 min · Pro

Other function groups

Updated Checked by running: every formula on this page was run by our formula engine on .