Excel – Formulae and Functions working with Dates and Times

Date/Time: Wednesday, 17th November 2021 - 11:00 am - 11:45 am

Location: Online

Available Spaces: 17

Contact Details: Marc Watson: marc.watson@nhs.net


This course will show you some very useful formulae and functions when dealing with dates.

  • Adding dates
  • Calculating number of days/months/years between 2 dates
  • Calculating working days
  • Date functions
    • Date
    • Day
    • Month
    • Year
    • Finding the name of a day or month from a date
  • Adding whole months to a date
  • Calculations with Times
    • Adding and subtracting hours
      • How to display the results correctly
  • Time functions
    • Time
    • Hour
    • Minute

Please be aware that the session is booked for 30 minutes and the extra 15 minutes are for any questions which may occur. You are not obligated to stay for the full 45 minutes.

You need to be logged in in order to be able to register for this event.
Please use the login form at the top of the page.