[SOLVED] IF Function to check if x date is before y date (not working) In the attached, I was working on my formula in column H trying to figure out why the result would always be equal to the "Invoice Amount" in column D, so I decided to simplify it and shorten it to see if the IF function was properly comparing dates. Please see column J - I cannot figure out why...
https://www.excelforum.com/sho....wthread.php?t=142294