Date and Time Functions

In this lesson, we will learn Date and Time functions in Excel. We will understand how to extract day, month, and year from dates, calculate date differences, and analyze working days using TODAY, NOW, DAY, MONTH, YEAR, DATE, EOMONTH, DATEDIF, and NETWORKDAYS. ## Lesson objective In this lesson, we will learn Date and Time functions in Excel. In the previous lesson, we learned text functions. We used , , , , , , , and to extract, combine, and clean text values. Now we move to working with date and time data. Many datasets in Excel contain date columns.