Hi BK LAAL,
Considering that your date field is in cell A1 and you wish to do this in excel itself, you can use the below:
=IF(TEXT(A1,"mm-dd-yy")=TEXT(NOW(),"mm-dd-yy"),"TODAY",IF(TEXT(A1,"mm-dd-yy")=TEXT(NOW()-1,"mm-dd-yy"),"YESTERDAY",TEXT(A1,"mm-dd-yy")))
Please let us all know if this...