=DATEVALUE("Thu, 01 Oct 2020 10:00:00 +0000")
but it results in
Error DATEVALUE parameter 'Thu, 01 Oct 2020 10:00:00 +0000' cannot be parsed to date/time.
- According to this, my locale should be set, but changing that can have other consequences in my sheet, which I do not want (FYI my current sheet locale is United States)
- According to this stackexchange question, there is apparently no support for that
Is there a workaround to get my manually entered RFC822 dates recognized by DATEVALUE formula Google Sheets (I need this particular formula to perform various operations, so other than re-entering dates in compliant format, is there anything else I can try?