=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 b2
On 2 Oct 2023 at 0:22, James wrote: Date sent:Mon, 2 Oct 2023 00:22:24 -0400 To:LibreOffice-list <users@global.libreoffice.org> From:James <bjloc...@lockie.ca> 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: users+unsubscr...@global.libreoffice.org > 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:mi...@guam.net mailto:msetze...@gmail.com Guam - Where America's Day Begins G4L Disk Imaging Project maintainer http://sourceforge.net/projects/g4l/ +------------------------------------------------------------+ -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org 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