To get today's dates into a cell, you can just use the TODAY function to equal TODAY, open brackets, closed brackets, press Enter, and there's today's date. Very useful if you want to work out things that are going to happen away from today's date. So maybe in a week's time, in a month's time, the number of days until a project will be completed, or the number of days left. Next up is the WORKDAY function. This gives you the date, a certain number of work days away from a beginning date. So I'm going to use today's date as the beginning date and I'm going to add on five workdays and I've just inserted a hard-code five further up the page. So I type in equals WORKDAY and it asks me for my start date. I'll use today's date. It then says how many days do you want to go away from that? I want to say five. I close the brackets and it now tells me that five working days from today is the 11th of July 17. End of month will give me the date a certain number of months away from a starting date, but then it'll give me the date at the end of the month. So to give an example, so equals EOMONTH.

It asks me for my start date. Again, I'll go with today's date. This is how many months do you want to go away from this? I want to go three months away from this. Again, I've just hard-coded a three up at the top here. So three months from the 4th of July will be 4th of August, 4th of September, 4th of October. But it won't return the 4th of October. It'll give me the end of October. It gives me the 31st of October. So useful reporting dates, maybe payroll, things that happen at the end of the month.