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!
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!