RossBossCurtis
Offline
Joined the community
11/9/22
Level 1
Level 1
Badges
Accepted Solutions
Likes Received
Posts
Discussions
Questions
Ideas
Blog Posts
-
How about this as a formula where A2 is March 16, 2024And where the formula is:=DATE(RIGHT(SUBSTITUTE(SUBSTITUTE(A2,", ","∞",1)," ","¢"),4),MONTH(DATEVALUE("1-"&TEXT(MID(SUBSTITUTE(SUBSTITUTE(A2,", ","∞",1)," ","¢"),1,FIND("¢",SUBSTITUTE(SUBSTITUTE(A2,", ","∞",1)," ","¢"))-1),"mm")&"-1900")),MID(SUB...Ideas
Type
385Views
0Likes
0Replies
4/15/24
Customize the badges you want to showcase on your profile
