Pull date from text string into new column

[PaulColbert]

Hello,
It's a great way to explore and discover new sexual fantasies and kinks in a safe and non-judgmental environment.


https://thegaywebcamchat.com/teen
https://couplesexcam.net/deepthroat
https://thegaylivechat.com/feet

[HansV]

Welcome to Eileen's Lounge!

Let's say the text strings are in D2 and down.
The date is returned by

=DATEVALUE(SUBSTITUTE(RIGHT(D2,11)," ","-"))

and to test whether the date is more than 85 days before today, you can use

=DATEVALUE(SUBSTITUTE(RIGHT(D2,11)," ","-"))<85

=DATEVALUE(SUBSTITUTE(RIGHT(D2,11)," ","-"))<TODAY()-85

This will return TRUE or FALSE.

[StuartR]

I think your second formula should have been

=DATEVALUE(SUBSTITUTE(RIGHT(D2,11)," ","-"))<(TODAY()-85)

[HansV]

Yes, of course. Thanks!

[snb]

Here this functions as well

=--RIGHT(A1;11)<TODAY()-85