Check if the date is falling within pre-defined date window

[ThrottleWorks]

Hi,

I am trying it get the results with formula in range C3:E5.
Can anyone please help me in this.

 

[NARAYANK991]

Hi Sachin ,

What is the logic ?

Narayan

 

[ThrottleWorks]

If date in column A or B is falling in either lower date or upper date from Row 1 or Row 2 dates then populate 1 else populate 0.
In any case result will be 0 or 1.

A3 is more than or equal to C1 that is why C3 = 1.
A3 is less than D1 that is why D3 = 0
A3 is less than E1 that is why E3 = 0
A4 is more than C1 and B4 is more than C2 so C4 = 0
A4 is more than D1 that is why D4 = 1
A4 is less than E1 by B4 is more than E1 so E4 = 1

 

[Marc L]

Hi !

Formula in cell C3 may be =N(A3>=C1) …
​

 

[NARAYANK991]

Hi Sachin ,

Please take a second look at what you have manually entered in the range C3:E5 ; it is not consistent with the logic you have given.

Can you first fill up the range C3:E5 manually ?

Narayan

 

[ThrottleWorks]

A3 is equal to C1, C3 = 1
A4 is more than C1, B4 is more than C2, C4 = 0
A5 is more than C1, B5 is more than C2, C5 = 0

 

[NARAYANK991]

Hi Sachin ,

See the attached file.

Narayan

 

[ThrottleWorks]

Thanks a lot @NARAYANK991 sir, good night. I am checking this and will revert.