Using time with IF

[JakeMann]

Hi All,

I need help with an IF formula and certain dates.

On the attached sheet I am using a formula in page 'formula' that matches column E to column B3 on page 'Machine 1'.

The formula goes lik this-

=IF(OR(E2='Machine 1'!$B$3,H2='Machine 1'!$B$5,H2='Machine 1'!$B$6,),COUNT(K$1:K1)+1,"")

It's not quite what I want as I need it to look for all instances of 1 - RV53B between todays date up to 2 weeks time.

Any ideas onto how to play with time in this?