Get the dd form 365 1

Welcome to XML matrix 783 hey if you want to download this workbook EXO matrix 779 276 click on the link below the video oh wow we have an epic video here this is date functions and formulas I'm going to show you seventeen examples hopefully this will sort of be a one-stop shopping for date functions and formulas dates here's a column of dates and if I look up here it says date number format if I apply the general format you see that it has a number underneath a serial number if I put the one number one here and apply a date we see that the first day that Excel knows is 1 1 1900 if I type a 2 here and then apply a number formatting short date I see 1 2 1900 so I'm going to ctrl Z on that undo one more time right so 4 0 5 8 5 that's how many days since December 31st 1899 there are and that will represent the number 2 11 2011 now serial dates are underneath and we'll do date math later first couple example just going to see how to get information from a date like we could say use the day Fox and the day function requires a serial number if you didn't know that dates were still number you mean like what is that so I'm going to click there and it will give me a day oh yeah that's the 11th day in the month if I double click and send this down that's all the day function it gives you a number between 1 and 31 now if you wanted the actual name of the day you'd have to use the text function text function requires any value knowing that a date is a number actually helps us understand that comment and then you have to know custom number formatting well um date number formatting is easy and now you have to put number formatting in double quotes and I want day right so I put D that would give me 11 DD that will give me 11 D DD that would give me if it's Monday it will give me mo n and if I put four DS it will give me the fully spelled out name thank you so that's Friday if I had two in there it would give me just FRA control Z for undo I'm going to double click and send that down so that's the actual day now a month well sometimes you want to see the month one is January two is February etc so you can use the month function notice it says serial number copy that down sometimes people have this as an extra column and then they can do an easy some if by month if you wanted the month spelled out like day over here you'd use text I'd give it this value comma and then if day is D what do you think month is right mm mm and then you can copy it all the way down sometimes these two items are used in some product formulas where you add a particular month and you need to match a word criteria against a serial date how about year equals what do you think the name of the year function is yeah it's year and year we look at a serial number just give the year same thing as a month sometimes people add extra columns like this and then it's easy to do a sum if by year now let's get a little going here and now watch this when I scroll over to the side I can't see that so I'm...