Jul 04 2024 08:53 AM
Hi
I need a formula that turns this value 20060323 (YYYMMDD) into a short date - 23/03/2006 (DD/MM/YYY)
I have had a google and a look on this messageboard but I haven't had much luck.
Thank you
Jul 04 2024 09:02 AM
With a number such as 20060323 in A1:
=DATE(QUOTIENT(A1, 10000), MOD(QUOTIENT(A1, 100), 100), MOD(A1, 100))
Apply the desired date format to the cell with the formula.
Jul 04 2024 09:04 PM
SolutionJul 04 2024 09:04 PM
Solution