Date Reformatting in Excel
In this video you will learn about date reformatting in Excel, including:
Common formats of dates using . and /
How to use a formula to reformat dates to enable them to be used in formulas
Dates are used all the time in Excel. Often companies import data into spreadsheets from other software packages which can save a lot of time. However unfortunately sometimes dates aren't copied over in the correct format. This can then be an issue if you want to do any date calculations of formulas. This date reformatting video looks at how you can a nested formula to reformat dates to make sure that they are in the correct format to then be able to be used in a formula.
Some related videos you might like:
The CONCATENATE Function in Excel - • The CONCATENATE Function in Excel
Text Manipulation in Excel - • Text Manipulation in Excel
We also have a number of playlists on our channel that you might like to look at. One of these being on Advanced Functions/Formulas in Excel - • Advanced Functions/Formulas in Excel
Our Date Reformatting in Excel video is also included in our hint and tip post that can be found on our website - https://www.jplcomputer.co.uk/2023/11...
If you would like more information about us, pop over to our website here - https://www.jplcomputer.co.uk/
#MsOffice #MsExcel