Countifs with Dates

[Jsleider]

Is it possible to use the Countifs function with dates? Say I have thirty customers expecting a delivery. I already have a sheet that runs the customer's expected delivery date. I am trying to run some countifs with a date range to single out the customer's that have not received delivery but are before today's delivery date, after today's delivery, and expecting delivery today.

For the customer's expecting it today, I use the below formula and it works perfect.

=Countifs(Data,"Not Delivered",Data,Today())

But I am trying to figure out if I can do one almost the same, but for deliveries before today's date and after today's date.

=Countifs(Data,"Not Delivered",Data,??????)

I appreciate any and all help. I am not sure if this is even possible. Thanks!

 

[Jsleider]

what is contained in the named range?

can you post a few rows of data ?

I was about to post some data when Canapone replied with a answer that worked. Thanks for your help and the time!

 

[Canapone]

Thank you for your very kind feedback: I would have been more precise.

Greetings from Firenze