=COUNTIF(ALL!AC2:AC1000,"<NOW()-21")
This is the formula I'm using. I'm trying to determine how many dates in column AC are more than three weeks ago. It's returning a 0 even though it shouldn't. Can anyone see why? THanks.
=COUNTIF(ALL!AC2:AC1000,"<NOW()-21")
This is the formula I'm using. I'm trying to determine how many dates in column AC are more than three weeks ago. It's returning a 0 even though it shouldn't. Can anyone see why? THanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks