Hello,

I'm trying to search data from another program with and IF statement and filter out dates and times. I have a mm/dd/yy hr:mm format in a series of cells. I've converted that to hh:mm using the MOD command. I also have a range of data that corresponds to each date in the next cell range. So far, I use this formula to evaluate the date:time cells for anything that is greater than 9:00 and less than 21:00. If this situation occurs, then I want it to show the corresponding data in the adjacent cell, otherwise leave blank.

For cell F37 formula is =IF((E37>TIME(8,59,0)+0)*(E37<TIME(21,1,0)),B37," ")

this works exactly as I want EXCEPT, I want to eliminate all weekends and holidays as well. What would I add to this formula to not only evaluate based on time, but on weekends and holidays as well.

Thanks in advance for any help.