• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 117
  • Last Modified:

IF(OR) Statement

Hi,

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?

Thanks



=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")
0
Seamus2626
Asked:
Seamus2626
1 Solution
 
Rgonzo1971Commented:
Hi,

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")

Regards
0
 
Seamus2626Author Commented:
Legend!
0

Featured Post

[Webinar] Cloud and Mobile-First Strategy

Maybe you’ve fully adopted the cloud since the beginning. Or maybe you started with on-prem resources but are pursuing a “cloud and mobile first” strategy. Getting to that end state has its challenges. Discover how to build out a 100% cloud and mobile IT strategy in this webinar.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now