MINIFS with INT

[gravanoc]

I have a table of forex currency data where the first column is a date time combination, i.e. 1/2/2022 17:30. I want to use MINIFS to determine the lowest number on a specific day that falls within the 3rd column, Low. Is there a way to specify this, for example on 4/5/22? My current workaround involves creating a new table and using Find and Replace to remove the time component. Then, MINIFS (tblData[Time], tblData[Low], B3) will work, where B3 is 4/5/22. What I'm looking for would somehow apply INT to the Time column in conjunction with MINIFS, but I'm not sure how.

 

[RoryA]

You could simply use two criteria - one >= the date you want and the next < the day after the one you want. That will include all times on the day in question.