IF(OR) Statement

Posted on 2014-08-13
Last Modified: 2014-08-13

I have an IF(OR) below

The formula result is "No" but the date serials match, so B17 is today()

Its checking date stamps dropped into the other spreadsheets by VB using =now()

Cutting the dates using left returns 41864 for all the cells in the IF and today()

Why am getting "No" returned?


=IF(OR(LEFT('[NA.xlsm]PB Review'!$H$1,5)=B17,LEFT('[Europe.xlsm]PB Review'!$H$1,5)=B17,(LEFT('[MENA.xlsm]PB Review'!$H$1,5)=B17),(LEFT('[Asia.xlsm]PB Review'!$H$1,5)=B17),(LEFT('[LATAM.xlsm]PB Review'!$H$1,5)=B17)),"Yes","No")
Question by:Seamus2626
    LVL 47

    Accepted Solution


    If you want to compare Today() and Now() you have to INT(Now()) = Today()

    =IF(OR(INT('[NA.xlsm]PB Review'!$H$1)=B17,INT('[Europe.xlsm]PB Review'!$H$1)=B17,INT('[MENA.xlsm]PB Review'!$H$1)=B17,INT('[Asia.xlsm]PB Review'!$H$1)=B17,INT('[LATAM.xlsm]PB Review'!$H$1)=B17),"Yes","No")


    Author Closing Comment


    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Join & Write a Comment

    Background What I'm presenting in this article is the result of 2 conditions in my work area: We have a SQL Server production environment but no development or test environment; andWe have an MS Access front end using tables in SQL Server but we a…
    Since upgrading to Office 2013 or higher installing the Smart Indenter addin will fail. This article will explain how to install it so it will work regardless of the Office version installed.
    The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …
    This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.

    755 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    21 Experts available now in Live!

    Get 1:1 Help Now