We help IT Professionals succeed at work.

excel formula to format text date then display comment

66 Views
Last Modified: 2017-05-31
G'day Experts
in attached file I have output from console in Column 'A' , trying if data in Column A is 'Yes' or 'is greater than 12/05/2017' then 'Latest Update' else 'Pending')

please help with excel formula

Thank you
Cheers
Mac
data_result.xlsx
Comment
Watch Question

CERTIFIED EXPERT
Top Expert 2016
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION
Mike in ITIT System Administrator
Distinguished Expert 2017

Commented:
I believe this will work fo you:
=IF(ISERROR(IF(A3="Yes","Latest Update",IF(MID(A3,FIND("/",A3,FIND("/",A3)+1)+1,4)>=2017,IF(MID(A3,FIND("/",A3)+1,2)>="05",IF(MID(A3,FIND("/",A3)-2,2)>"12","Latest Update","Pending"),"Pending")))),"Pending",IF(A3="Yes","Latest Update",IF(MID(A3,FIND("/",A3,FIND("/",A3)+1)+1,4)>=2017,IF(MID(A3,FIND("/",A3)+1,2)>="05",IF(MID(A3,FIND("/",A3)-2,2)>"12","Latest Update","Pending"),"Pending"))))

Open in new window


Just put it in C and then copy it down.

Author

Commented:
thank you

Author

Commented:
thank you Mike, Apologies  as just accepted Rgonzo1971solution
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.