When you need to apply a small tweak to the document, it must not take long to Consolidate date warranty. This kind of simple action does not have to require extra education or running through manuals to learn it. Using the proper document editing tool, you will not spend more time than is necessary for such a swift change. Use DocHub to streamline your editing process whether you are an experienced user or if it is your first time using a web-based editor service. This instrument will require minutes to learn how to Consolidate date warranty. The only thing required to get more productive with editing is a DocHub profile.
A plain document editor like DocHub can help you optimize the amount of time you need to dedicate to document editing regardless of your previous knowledge of this kind of instruments. Create an account now and enhance your efficiency immediately with DocHub!
hi in this video Im going to show you how to take data thats a date and thats 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 its 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 its actually pretty easy to use so I can do is go into this column type of date and select the date function and its gonna take three arguments the Year month and day so Im gonna select the year here comma months comma and day and just press ENTER and youll 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 e
