How to write a formula for google spreadsheets depending on time?

Question

Google Sheets

Good afternoon.
Please tell me How to take data from cell A
, provided that this entry was made on the same date and an element from the directory is selected
Example of a table by reference
how to combine these 2 formulas
1";'Couriers'!B:B;"") how to add a date dependency here?
here is a sample solution from date
=IF(EVEN(DAY(TODAY()));"select B, E, C where C >0";"select B, E, C where C <0")
=IF('Couriers' !D:D= "Warehouse 1";'Couriers'!B:B;"")