There are a number of date functions in Excel. The first one, the Date function itself gives you a serial date. Now that will give you the number of days from the first of January, 1900. And we use the Year function, month function and day function to build up those serial parts. As a date is given to you as the number of days since the first of January, 1900 you can then work out the number of days between two other dates. So maybe the number of days since your birthday. The number of days since the start of the year. Or the number of days until the end of a project. The Today function or Now function, very useful for inputting today's date and it automatically updates whenever you open up your file. Weekday refers to a date in this case in cell A1 and it tells you what day of the week that is. So for instance, it could tell you that you're going to finish your project on a Tuesday. Or could tell you what day of the week you were born on. Workday works out a specific date after a number of working days. So for instance, I could put in today's date I could then add on five working days and it would give me the date in five working days time. Networkdays is the working days between two dates. And EOMonth gives you the date at the end of a month. So for instance if we had a date that was the 3rd of December it would then automatically calculate the 31st of December. DatesDif gives you the number of years, months or days between two dates. And EDate allows you to set a date a number of months before or after a specific date. Very useful if you were to put a date into a calendar, so maybe the 1st of January 2020, and then the cell nextdoor you enter the 1st of January, 2021. Cell nextdoor to that 1st of January, 2022.