May 16 2022 03:11 PM
Hello. I am trying to run a report that will confirm if an invoice was dated on or before 01/01/2020. The formula I am using works only if the invoices are dated before the date specified, it does not include anything invoiced on 01/01/2020. I receive a NO in the cell if anything is dated 12/31/2019 but I also get a NO in the cell if the invoice is dated 01/01/2020. I have been looking at this spreadsheet for too long and I am unable to figure it out. This is the formula I am using:
=IF(F2>$O$1,"YES","NO")
F2 is the cell with the invoice date. $O$1 is the cell with 01/01/2020 filled in it. I didn't generate this formula and I am unfamiliar with the $ symbol and what it does. I am sure this is just a simple fix, hoping someone can share some guidance. Thank you!
May 16 2022 04:27 PM