MustaphaOj
New Member
- Joined
- Jul 8, 2020
- Messages
- 20
- Office Version
- 2016
- Platform
- Windows
Hi All,
I have a particularly tricky task as I have a big data set that I am sitting through looking for some dates. Sounds simple enough until
You see some are formatted like this
“14-09-20 A” while the rest are formatted like “14/07/2020”
My question is if I wanted to make a formula that searches the whole data set looking for dates after a certain date (let’s say 23/07/2029) WITH the “A” included how would I go about it?
I have a particularly tricky task as I have a big data set that I am sitting through looking for some dates. Sounds simple enough until
You see some are formatted like this
“14-09-20 A” while the rest are formatted like “14/07/2020”
My question is if I wanted to make a formula that searches the whole data set looking for dates after a certain date (let’s say 23/07/2029) WITH the “A” included how would I go about it?
Name | Date | |
Mark | 14-09-20 A | |
John | 15/07/2020 | |
Peter | 17-06-18 A |