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?
Bookmarks