Feb 17 2022 02:53 PM - edited Feb 17 2022 03:24 PM
ex:
DATE | DATE | AGE |
Friday, February 11, 2022 | Thursday, July 28, 1988 | 33 |
2.16.22 | 1.18.14 |
FORMAT (LONG DATE) WOULD AUTO CORRECT WHEN TYPED IN (SHORT DATE) FORMAT. IT NO LONGER WORKS AND I CANT SEEM TO MAKE IT WORK AGAIN. WITHOUT (LONG DATE) FORMAT (AGE COLUMN) WONT CALCULATE.
PLEASE HELP
Feb 17 2022 08:49 PM
Solution@TAMMYT_A Then you are probably entering text that Excel doesn't recognise as a date. The cells you enter the dates in are perhaps formatted as text. Setting them to Long Data after entry will not be enough. You would have to re-enter the date (select the cell, F2 and press enter).
Or did you recently change some some regional settings? Does the "2.16.22" format agree to your locale? Perhaps you need to enter 2/16/22 or 2-16-22 or 2022-02-16.
Feb 18 2022 09:47 AM
Feb 17 2022 08:49 PM
Solution@TAMMYT_A Then you are probably entering text that Excel doesn't recognise as a date. The cells you enter the dates in are perhaps formatted as text. Setting them to Long Data after entry will not be enough. You would have to re-enter the date (select the cell, F2 and press enter).
Or did you recently change some some regional settings? Does the "2.16.22" format agree to your locale? Perhaps you need to enter 2/16/22 or 2-16-22 or 2022-02-16.