N Nabeel Member May 24, 2015 #1 hello all plz find attached..i am compering two dates.i want when there is no date in ref cell the resulted cell should be empty or has only dash. BR Attachments sample.xlsx sample.xlsx 8.7 KB · Views: 0
hello all plz find attached..i am compering two dates.i want when there is no date in ref cell the resulted cell should be empty or has only dash. BR
Deepak Excel Ninja May 24, 2015 #2 @Nabeel Is this.. =IF(COUNTBLANK(E9:F9),"",IF(E9<F9,"One Month Resign","One Day Resign"))
Deepak Excel Ninja May 24, 2015 #3 Or this.. =IF(COUNTA(E10:F10)=0,"",IF(E10<F10,"One Month Resign","One Day Resign"))
