Date function

Question

Hello,&nbsp;could you please help with the question in the file attached&nbsp;thanks

hansvogelaar · Answer

Ahmad920&nbsp;
=COUNTIFS(D14:D963,"&lt;"&amp;TODAY()-100,E14:E963,"")

sergeibaklan · Answer

Ahmad920&nbsp;
There are more blanks which are considered as open

hansvogelaar · Answer

Ahmad920&nbsp;
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,"&gt;"&amp;TODAY()-100,E14:E963,"")

ahmad920 · Answer

Thanks&nbsp;HansVogelaar&nbsp;but when I use your formula I get&nbsp; 397&nbsp; while there is only 7 dates in 2020

ahmad920 · Answer

Thanks&nbsp;SergeiBaklan&nbsp;&nbsp;actually 2 conditions have to be met together:1- case open2- date: in the last 100 daysso the answer should be 6 , but I cant get this result&nbsp;

Forum Discussion

Date function

8 Replies

Resources