Forum Discussion
Date function
Hello, could you please help with the question in the file attached thanks
=COUNTIFS(D14:D963,"<"&TODAY()-100,E14:E963,"")
Thanks HansVogelaar
but when I use your formula I get 397 while there is only 7 dates in 2020
There are more blanks which are considered as open
Thanks SergeiBaklan you are right
Thanks SergeiBaklan
actually 2 conditions have to be met together:
1- case open
2- date: in the last 100 days
so the answer should be 6 , but I cant get this result
Oh wait, your request was incorrect. You don't want cases that have been open for more than 100 days, but instead cases that have been open for less than 100 days!
That is
=COUNTIFS(D14:D963,">"&TODAY()-100,E14:E963,"")
