Multiple if Condition with Date

Hi all,

Thank you in advance.


I have attached an excel sheet (test) where the columns are mentioned.

I have two date columns (C and D)

if the dates entered in these columns are less than todays date...then i need to print "do not accept" else "accept" in remark column (E)

both the dates should be checked

is it possible???

Please help


regards,

Gokul

Hello Ace_XL,

Thanks

when i tried with one valid date and other invalid..it is still showing accept.

for example first expiry date is 1/12/2015(mm/dd/yyyy) and second one is 1/13/2015...the remark is accept

how can we sort this??

Gokul

If both days are less then today -- do not accept
If two days is equal or more -- accept
If one day is lesser - do not accept