Today -A1 The result should be 42 as my date today is 12219. How to change date format in Excel Select the dates whose format your want to change or empty cells where you want to insert dates. Select the columns on which you want to perform the find and replace.
In the Format Cells window switch to the.
One click to convert mmddyyyy format or other date format to mmddyyyy with Kutools for Excel. If not then both these functions will return a VALUE error. How to change date format in Excel Select the dates whose format your want to change or empty cells where you want to insert dates. One click to convert mmddyyyy format or other date format to mmddyyyy with Kutools for Excel.