Workdays, due dates, ages, financial years and time calculations. This page lists all 25 of them; each links to a full lesson with an example you can copy and a practice file.
DATEDATE creates a real date from separate year, month and day numbers — the reliable way to put…DATEDIFDATEDIF is a hidden function (not in the autocomplete list) that returns the difference between two dates in…DATEVALUEDATEVALUE turns a date written as text into a real date number. It follows your Windows regional settings,…DAYDAY returns 1–31 from a date. Pair it with YEAR and MONTH to rebuild or test dates.DAYSDAYS returns the number of days between two dates. Subtracting the dates (=B2-A2) gives the same answer.DAYS360DAYS360 counts days as if every month had 30 — the convention some interest and bond calculations use.EDATEEDATE returns the same day a number of months before or after a date — ideal for due…EOMONTHEOMONTH returns the last day of the month, a number of months away from a date.HOURHOUR returns 0–23 from a time or date-time. The quickest way to group call-centre or sales data by…ISOWEEKNUMISOWEEKNUM returns the ISO 8601 week (weeks start on Monday; week 1 holds the first Thursday). Use it…MINUTEMINUTE returns 0–59 from a time.MONTHMONTH returns 1 for January through 12 for December — the building block for monthly reports and fiscal-period…NETWORKDAYSNETWORKDAYS counts Monday–Friday working days between two dates, optionally excluding a holiday list. NETWORKDAYS.INTL lets you choose the…NETWORKDAYS.INTLNETWORKDAYS.INTL counts working days when your weekend is not Saturday–Sunday — a Sunday-only week, or a Friday–Saturday weekend…NOWNOW returns the current date and time and updates every time the sheet recalculates. For a timestamp that…SECONDSECOND returns 0–59. Mostly used to strip seconds from machine timestamps.TIMETIME creates a time value. Excel stores time as a fraction of a day: 12:00 is 0.5, 6:00…TIMEVALUETIMEVALUE turns text like "2:45 PM" into a real time you can add and subtract.TODAYTODAY returns today’s date and recalculates whenever the workbook changes or opens. NOW adds the time.WEEKDAYWEEKDAY returns a number for the day of the week. Type 2 makes Monday = 1 … Sunday…WEEKNUMWEEKNUM returns the week of the year. ISOWEEKNUM follows the ISO standard (weeks start Monday, week 1 contains…WORKDAYWORKDAY returns the date that is a number of working days before or after a start date, skipping…WORKDAY.INTLWORKDAY.INTL adds working days with a custom weekend — delivery or SLA dates for a six-day operation.YEARYEAR returns the four-digit year of a date. MONTH and DAY work the same way for the month…YEARFRACYEARFRAC returns the fraction of a year between two dates — for pro-rata interest, depreciation and exact age.