I can't round down the soure data, as I do need to access the time info on occasion. But I tried to implement the round down and can't get it do a count on my summary page. What am I doing wrong?

=COUNTIF(ROUNDDOWN('ACT Legacy'!F2,0)-ROUNDDOWN('ACT Legacy'!F2000,0),A9)