I may be missing something, but $timeISO or $timeUnix would use the current time. So each time that I load the sheet, the time would always contain the current time and that is incorrect. Stringify passes the time and date that I enter or leave an area, and that string has nd after 2nd, rd after 3rd, etc. and Google Sheets Date functions do not recognize this as a valid date. Thought I had it by using the SPLIT function and splitting on st, or nd, or rd, or th by grouping them in "stndrdth", and all through december it worked as expected, then In January, well there is a n in Jan so it splits on the first n from the string above. I could create a dizzying extra long OR statement and check for each ending(st or nd,etc) and Split accordingly, but was hoping that REGEX could do this somewhat quicker. Most of what I had read so far indicates that REGEX may not be the best tool for this. Life would be so much easier if Stringify had an alternate format available dates or if it simply got rid of the extra "flourish" and let 1st be 1, 2nd be 2, etc.