Comparing dates in Excel

 Published On

On my project, I am not 100% on development. My job also requires preparation of integration tests which consist of getting an excel file from business people, extract the information and compare them with the information the system generates.

I encountered a strange and silly problem today while working on excel: I needed to validate if two columns have the same value. On the right side, I have a value formatted like :


and on the left side I have another date value formatted like :


When I did

=A1 = A2

the result was false. A colleague of mine suggested the following and it works :


Tags:   date comparison   excel   project


comments powered by Disqus

© 2017 - Mechanical Object. All rights reserved
Built using Jekyll