SOLVED

LONG DATE FORMAT ISNT FORMATING ANYMORE.

%3CLINGO-SUB%20id%3D%22lingo-sub-3181679%22%20slang%3D%22en-US%22%3ELONG%20DATE%20FORMAT%20ISNT%20FORMATING%20ANYMORE.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3181679%22%20slang%3D%22en-US%22%3E%3CP%3Eex%3A%3C%2FP%3E%3CTABLE%20width%3D%22534px%22%3E%3CTBODY%3E%3CTR%3E%3CTD%20width%3D%22203.76px%22%3EDATE%3C%2FTD%3E%3CTD%20width%3D%22202.76px%22%3EDATE%3C%2FTD%3E%3CTD%20width%3D%22126.479px%22%3EAGE%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3CTABLE%20width%3D%22537px%22%3E%3CTBODY%3E%3CTR%3E%3CTD%20width%3D%22198.74px%22%3EFriday%2C%20February%2011%2C%202022%3C%2FTD%3E%3CTD%20width%3D%22205.76px%22%3EThursday%2C%20July%2028%2C%201988%3C%2FTD%3E%3CTD%20width%3D%22131.5px%22%3E33%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22198.74px%22%3E2.16.22%3C%2FTD%3E%3CTD%20width%3D%22205.76px%22%3E1.18.14%3C%2FTD%3E%3CTD%20width%3D%22131.5px%22%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3CP%3EFORMAT%20(LONG%20DATE)%20WOULD%20AUTO%20CORRECT%20WHEN%20TYPED%20IN%20(SHORT%20DATE)%20FORMAT.%20IT%20NO%20LONGER%20WORKS%20AND%20I%20CANT%20SEEM%20TO%20MAKE%20IT%20WORK%20AGAIN.%20WITH%20OUT%20(LONG%20DATE)%20FORMAT%20(AGE%20COLUMN)%20WONT%20CALCULATE.%3C%2FP%3E%3CP%3EPLEASE%20HELP%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3181679%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20for%20web%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3182389%22%20slang%3D%22en-US%22%3ERe%3A%20LONG%20DATE%20FORMAT%20ISNT%20FORMATING%20ANYMORE.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3182389%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1310815%22%20target%3D%22_blank%22%3E%40TAMMYT_A%3C%2FA%3E%26nbsp%3BThen%20you%20are%20probably%20entering%20text%20that%20Excel%20doesn't%20recognise%20as%20a%20date.%20The%20cells%20you%20enter%20the%20dates%20in%20are%20perhaps%20formatted%20as%20text.%20Setting%20them%20to%20Long%20Data%20after%20entry%20will%20not%20be%20enough.%20You%20would%20have%20to%20re-enter%20the%20date%20(select%20the%20cell%2C%20F2%20and%20press%20enter).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EOr%20did%20you%20recently%20change%20some%20some%20regional%20settings%3F%20Does%20the%20%222.16.22%22%20%26nbsp%3Bformat%20agree%20to%20your%20locale%3F%20Perhaps%20you%20need%20to%20enter%202%2F16%2F22%20or%202-16-22%20or%202022-02-16.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

ex:

DATEDATEAGE
Friday, February 11, 2022Thursday, July 28, 198833
2.16.221.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

2 Replies
best response confirmed by Sergei Baklan (MVP)
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.

oh my goodness I can't believe it was as simple as 2/16/22 thank you so much.