Merge Mark Age with airSlate SignNow

Combine date warranty

hi in this video I'm going to show you how to take data that's a date and that's separated into separate columns such as the month day and year and combine it all into one column so it makes it a little bit more easy to use and view so it's basically a pretty easy type of function the function used to combine the month day and year all into one cell is the date function and it's actually pretty easy to use so I can do is go into this column type of date and select the date function and it's gonna take three arguments the Year month and day so I'm gonna select the year here comma months comma and day and just press ENTER and you'll see that it has showed up now we see that the the value is kind of nicely formatted here and Excel is smart enough to figure out that this is a date but sometimes when Excel uses day formula you get this general no specific date formula and this is basically the serial number format which Excel sees dates and the way it displays States is what I showed you earlier it has a either a short date here or you can do it as a long date here and let me go double click this to increase the size so you can see it but basically once you get the user date function and get the separate year month and day you can come back in to the serial number format you can use the date these date functions or you can go into more number formats and use different types of formatting style so maybe if you like something else like maybe you wanted to see it like this it can show it up like that and click OK and we can show something like that where you have two date month and year but I kind of like it with the the short date and we can just go ahead and select that double click the fill handle to bring it down and we'll see with the each of the different date functions here the arguments have been copied down respective to the cells here so that's how we can use a date function to combine the month day and year when they show up in different columns of a spreadsheet so we can make it easier and put it into one column so I hope that helps thanks for watching you