Here we've got a date of birth at 10th of June, 1970. What we'd like to do is isolate the various different parts of this. So I'm gonna start firstly with the day and I'm going to use Excels DAY function to help me. The DAY function says look at a particular date and then just extract the day, and it gives me the 10th. The MONTH function can be used to extract the month, June, or in this case six.

And lastly, the YEAR function can extract just the year. In this case, 1970. What we can then do is we can use the DATE function to bring all those items back together. So if I type in date, it now asks me what year would you like? Well, I would like 1970. What month would you like? Six. And what day would you like? That would be the 10th.

Fantastic. And now I've got the 10th of June, 1970. I can then use that function to start advancing certain things there. For instance, I might want to advance the years in which case I go back into the years part and I add one, and I'm now into 71. I could then copy that right and that would become 72, 73, 74, for instance. Useful if I want to do headings. You can also put all of those together, the day, month, and year, all within the DATE function so it's not spread out over so many cells. So to start it again, I could do equals date and I could put in the YEAR function. My serial number will come from the original date.

It then asks me, what month do you want? I want the month from that date of birth again. And then lastly, what day do you want? So there's the date that has appeared one more time, but again, if I wanted to advance the years, add one, goes to 71, add two, goes to 72, et cetera.