I have a table that counts how many people have presented on a certain date in hour intervals. I use the following formula to gather this data:
When writing the formula I have to enter the date manually into each cell I want it to look for the date within raw data. Is there any way I can set the formula up without having to change the date in each cell but have it look up the value I want to capture from a certain cell instead?
Thanks

Code:
=COUNTIFS('Patient Summary'!B6:B453,"[B]21/7/2018[/B]",'Patient Summary'!C6:C453,">=02:00",'Patient Summary'!C6:C453,"<03:00")
When writing the formula I have to enter the date manually into each cell I want it to look for the date within raw data. Is there any way I can set the formula up without having to change the date in each cell but have it look up the value I want to capture from a certain cell instead?
Thanks