IF/ OR

NLILA

Hello, I am trying to create a formula that encompasses multiple dates. The current formula I have is as follows:

=IF($[In Date]5 = ($[In Date]$4 + [03-OCT]$4), $[Day Type In]5, IF($[Out Date]5 = ($[In Date]$4 + [03-OCT]$4), $[Day Type Out]5, IF(AND($[In Date]5 < ($[In Date]$4 + [03-OCT]$4), $[Out Date]5 > ($[In Date]$4 + [03-OCT]$4)), "W", "°")))

I have added 4 more columns that I need to add to the in as a OR function.

In Date 2, Out Date 2, Day Type In 2, Day Type Out 2

Bit of a novice with this so any direction would be great!

Jason Albrecht

Hi Nlila,

It might be helpful to take a screenshot of the sheet in question?

If I'm understanding the request, I wonder if the following will help...

=IF(OR(

$[In Date]5 = ($[In Date]$4 + [03-OCT]$4),

$[In Date]5 = ($[In Date]$2 + [03-OCT]$4),

$[In Date]5 = ($[Day Type In]$2 + [03-OCT]$4)),

$[Day Type In]5,

IF(OR(

$[Out Date]5 = ($[In Date]$4 + [03-OCT]$4),

$[Out Date]5 = ($[In Date]$2 + [03-OCT]$4)

$[Out Date]5 = ($[Day Type In]$2 + [03-OCT]$4)

$[Day Type Out]5,

IF(AND($[In Date]5 < ($[In Date]$4 + [03-OCT]$4), $[Out Date]5 > ($[In Date]$4 + [03-OCT]$4)),

"W", "°")))

NLILA

Thank you Jason. I tried that and it still being a little wonky. Here is a screenshot of the sheet.

Thank you!

Jason Albrecht

Thanks @NLILA

I may need to hand off to others in the community who may be able to help.

I'm not sure of the context, which cell you're putting the formula in or how to account for errors, sorry.