Date function

[Ahmad920]

Hello,

could you please help with the question in the file attached

thanks

[#2]

@Ahmad920 

=COUNTIFS(D14:D963,"<"&TODAY()-100,E14:E963,"")

[#3]

Thanks @Hans Vogelaar 

but when I use your formula I get  397  while there is only 7 dates in 2020

[#4]

@Ahmad920 

There are more blanks which are considered as open

[#5]

Thanks @Sergei Baklan 

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

[#6]

@Ahmad920 

Your request was

"4. number of the cases which still open for more than 100 day , using formula"

There are 397 such cases:

I don't see how you arrived at 6.

[#7]

@Ahmad920 

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,"")

[#8]

Thanks @Sergei Baklan  you are right

[#9]

Thanks @Hans Vogelaar so much

you are right 

Thanks a million