=IF(ISNUMBER(A1),A1,DATEVALUE(MID(A1,FIND(",",A1)+2,20)))
Put dates in A1 and A2
Sun, Jan 1, 2024 isn't a date
Sunday, Jan 1, 2024 is a date.
Put formula in B1, and copied to b2On 2 Oct 2023 at 0:22, James wrote: Date sent:Mon, 2 Oct 2023 00:22:24 -0400 To:LibreOffice-list <[email protected]> From:James <[email protected]> Subject:[libreoffice-users] text to date > The shortform of a day (eg. Sun) is not recognized as a date but the > fullname (eg. Sunday) is. > > Sun, Jan 1, 2024 isn't a date > Sunday, Jan 1, 2024 is a date. > > Does anyone know how to converttext in the format NN, MMM D, YYYY to a date? > > -- > To unsubscribe e-mail to: [email protected] > Problems? > https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ > Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette > List archive: https://listarchives.libreoffice.org/global/users/ > Privacy Policy: https://www.documentfoundation.org/privacy +------------------------------------------------------------+ Michael D. Setzer II - Computer Science Instructor (Retired) mailto:[email protected] mailto:[email protected] Guam - Where America's Day Begins G4L Disk Imaging Project maintainer http://sourceforge.net/projects/g4l/ +------------------------------------------------------------+ -- To unsubscribe e-mail to: [email protected] Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
