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() = Thursday 09 July 2020
2=NOW() = Thursday 09 July 2020 12:28:52
3=TEXT(A1,"yyyymmdd") = 20200709
4=DATEVALUE(RIGHT(A3,2)&"/"&MID(A3,5,2)&"/"&(LEFT(A3,4))) = Thursday, July 09, 2020
5=DATEVALUE(RIGHT(A3,2)&"/"&MID(A3,5,2)&"/"&(LEFT(A3,4))) = Thursday, July 09, 2020

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


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