Convert a date string to a date value

If you have any dates entered as a string (e.g. "20050701" in the format "yyyymmdd") the formula in cell "A4" will convert it to the corresponding date serial number.
All these cells have been formatted with the custom number format "dd dddd mmmm yyyy".

 A
1=TODAY() = 02/12/2019
2=NOW() = 02/12/2019
3=TEXT(A1,"yyyymmdd") = 20191202
4=DATEVALUE(RIGHT(A3,2)&"/"&MID(A3,5,2)&"/"&(LEFT(A3,4))) = Monday, December 02, 2019
5=DATEVALUE(RIGHT(A3,2)&"/"&MID(A3,5,2)&"/"&(LEFT(A3,4))) = Monday, December 02, 2019

Built-in Functions

NOW - The serial number of the current system date and time.
TODAY - The serial number representing today's date.
DATEVALUE - The date serial number given a date in text format.
TEXT - The number as a formatted text string.


Related Formulas

Return a date in US date format


© 2019 Better Solutions Limited. All Rights Reserved. © 2019 Better Solutions Limited Top