Before or after current date - dates in specific format - Excel

[MarissaB]

Hi all,

I have a large dataset with the due dates stated in the way you can see in the attachment. I would like to get an overview if the due date is before the current date [TODAY()]. However, as you can see the formula is not working as AY2 needs to be "PAID".

Could you please help me? Thanks a lot!
Marissa

 

[CA_Punit]

What is the result showing????

Is it showing Error or ???

 

[MarissaB]

Cell AY2 is 'overdue' while it should be to be paid

 

[CA_Punit]

I Suppose there is date format issue. Please post a sample using xl2bb

Just check for xl2bb addin in the right hand side of the reply box and download it