I'm working in Google Sheets and I am trying to determine if any value of dates listed in the column is equal to Today's Date.
I have tried using the COUNTIF
formula the ISDATE
formula and the IF
formula against the value of TODAY()
and nothing seems to be working right.
=IF('Invoices-Quickbooks-Data'!L:L,ISDATE(TODAY()),true)
This formula actually works the best for me. I would expect it to calculate if any of the values equal Today's Date. Ironically this tells me that the answer is TRUE
even when none of the dates actually match Today's date so I am not sure what is going on.
Aucun commentaire:
Enregistrer un commentaire