© The Author(s), under exclusive license to APress Media, LLC, part of Springer Nature 2022
A. MurrayAdvanced Excel Formulashttps://doi.org/10.1007/978-1-4842-7125-4_6

6. Working with Dates and Time

Alan Murray1  
(1)
IPSWICH, UK
 

It is almost inevitable that you will work with dates and time in Excel, regardless of your job role or profession. Excel contains more than 20 awesome functions for you to perform the date and time calculations that you need.

This chapter begins with a guide to how dates and time work in Excel. It is very important that we understand the calendar system of Excel before we begin writing our formulas.

We then proceed into explanations of the most used date and time functions with examples using them to solve a myriad of typical ...

Get Advanced Excel Formulas: Unleashing Brilliance with Excel Formulas now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.