Learn Excel
EN
Sets how numbers, dates and formulas look, so everything works just like your own Excel.

Home › Learn Excel › Lesson 13

Working with dates in Excel

Build dates, work out ages and durations, find the end of a month and count working days.

  1. Build a date: DATE. DATE builds a real date from a year, a month and a day, always in that order. Turn the year, month and day into one date, in D2
  2. Today: TODAY. TODAY returns today's date and updates every day. It needs nothing between the brackets. Show today's date in B2
  3. An age: DATEDIF. DATEDIF counts the full years between the date of birth and TODAY(), so the age updates by itself. Work out in C2 how old Sam is today
  4. Dates are numbers.
  5. End of the month: EOMONTH. EOMONTH returns the last day of a month. A 0 at the end means the same month, 1 means next month. Find the last day of the month of the invoice date, in B2
  6. Your turn: working days. NETWORKDAYS counts the weekdays between two dates, the first and last day included. Weekends don't count. Count the working days between the two dates, in C2

← All lessons