With
A1 containing your source text
This regular formula returns the number of days remaining until the embedded date plus 40 days
Is that something you can work with?![]()
B1: =(TEXT(MID(B1,FIND("-",B1)+1,8),"00-00-0000")+40)-TODAY()
With
A1 containing your source text
This regular formula returns the number of days remaining until the embedded date plus 40 days
Is that something you can work with?![]()
B1: =(TEXT(MID(B1,FIND("-",B1)+1,8),"00-00-0000")+40)-TODAY()
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks