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
Pull date from text string into new column
-
- NewLounger
- Posts: 1
- Joined: 23 Aug 2023, 02:55
Pull date from text string into new column
Last edited by PaulColbert on 12 Mar 2024, 03:50, edited 1 time in total.
-
- Administrator
- Posts: 78625
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Pull date from text string into new column
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.
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)," ","-"))<TODAY()-85
This will return TRUE or FALSE.
Best wishes,
Hans
Hans
-
- Administrator
- Posts: 12629
- Joined: 16 Jan 2010, 15:49
- Location: London, Europe
Re: Pull date from text string into new column
I think your second formula should have been
=DATEVALUE(SUBSTITUTE(RIGHT(D2,11)," ","-"))<(TODAY()-85)
=DATEVALUE(SUBSTITUTE(RIGHT(D2,11)," ","-"))<(TODAY()-85)
StuartR
-
- Administrator
- Posts: 78625
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
-
- 4StarLounger
- Posts: 588
- Joined: 14 Nov 2012, 16:06
Re: Pull date from text string into new column
Here this functions as well
=--RIGHT(A1;11)<TODAY()-85
=--RIGHT(A1;11)<TODAY()-85