Results 1 to 2 of 2

Using time with IF

Threaded View

  1. #1
    Forum Contributor
    Join Date
    06-20-2012
    Location
    Derby
    MS-Off Ver
    Excel 2010
    Posts
    383

    Using time with IF

    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?
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1