Getting comprehensive control over your documents at any time is important to relieve your daily tasks and boost your productivity. Accomplish any objective with DocHub tools for document management and hassle-free PDF editing. Gain access, change and save and incorporate your workflows along with other secure cloud storage services.
DocHub gives you lossless editing, the possibility to work with any format, and safely eSign documents without the need of searching for a third-party eSignature alternative. Get the most from the file managing solutions in one place. Check out all DocHub capabilities right now with the free profile.
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