CODEWITHSUNDEEP
excel
Peter Vajda
Peter Vajda

Reputation: 29

How to use date comparison with Today() in Excel array formula?

I have this array formula:

{=SUM(COUNTIFS(Overview!E:E;{"<=2020-04-22"};Overview!F:F;{"Working";"Review"}))}

It works. But when changing the date to TODAY() function, it breaks. This does not work, says error in formula:

{=SUM(COUNTIFS(Overview!E:E;{"<=" & TODAY()};Overview!F:F;{"Working";"Review"}))}

How can I enter the TODAY() into the array formula for date comparison? I think it has something to do with the quotes, but double or triple quoting does not help.

Thank you!

Upvotes: 0

Views: 325

Answers (1)

Peter Vajda
Peter Vajda

Reputation: 29

Apparently this can be done with extra pair of quotes (five pairs in total):

{"""<="" & TODAY() &"""""}

Upvotes: 1

Related Questions