Re: [libreoffice-users] text to date

=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 <bjlockie@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+unsubscribe@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:mikes@guam.net
mailto:msetzerii@gmail.com
Guam - Where America's Day Begins
G4L Disk Imaging Project maintainer
http://sourceforge.net/projects/g4l/
+------------------------------------------------------------+




-- 
To unsubscribe e-mail to: users+unsubscribe@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