Need to add or function to if function

[howard]

I have the following formula in Col G

=IF(LEFT(B2,2)="UC","COS",IF(AND(B2="F22200",F2=""),"COS",IFERROR(VLOOKUP(F2,'unique Suppliers & Codes'!A:B,2,FALSE),"")))

I would like the formula amended so that if Col F contains a date format dd/mm/yyyy for eg 03/04/2018 then it must return COS in COL G, otherwise use IFERROR(VLOOKUP(F2,'unique Suppliers & Codes'!A:B,2,FALSE),"")))


it would be appreciated if someone could amend my formula so that if there is a date in Col F (I use dd/mm/yyyy). it would return COS


Your assistance in this regard is most appreciated

 

[Yongle]

Try

=IF(NOT(ISERROR(DATE(DAY(F2),MONTH(F2),YEAR(F2)))),"COS",IFERROR(VLOOKUP(F2,'unique Suppliers & Codes'!A:B,2,FALSE),""))


This tests to see if F2 contains a valid date
=NOT(ISERROR(DATE(DAY(F2),MONTH(F2),YEAR(F2))))

 

[howard]

Thanks for the help, Yongle