Between Two Dates

[Utradeshow]

Hi All,

Trying to come up with a formula that will tell me if a column of dates is between the criteria in columns I and J.

Last In last Out Dates.xlsx
	I	J	K	L	M
1	START	END	Between	IN	OUT
2	1/1/2024	1/31/2024	YES	12/15/2023	1/15/2024
3			NO	12/17/2023	12/22/2023
Sheet1

 

[awoohaw]

Your question is confusing, you mention a column but you seem to have two columns, so unsure what column you're comparing.
But try this:

Book1
	I	J	K	L	M	N	O
1	START	END	Between	IN	OUT	If Check Col L	If Check Col M
2	2024-01-01	2024-01-31	YES	2023-12-15	2024-01-15	No	Yes
3			NO	2023-12-17	2023-12-22	No	No
Sheet4

Cell Formulas
Range	Formula
N2:O3	N2	=IF(((L2>=$I$2)*(L2<=$J$2)),"Yes","No")

 

[Utradeshow]

The scenario is for STORAGE Billing. If items are in storage for even one day in January in this case the return would be YES.

The (input) cells or criteria is entered in I2 and J2. So in this case the formula in cell K2 would check if the item dates in L2 and M2 was here any day in January.

Last In last Out Dates.xlsx
	I	J	K	L	M
1	START	END	Between	IN	OUT
2	1/1/2024	1/31/2024	YES	12/15/2023	1/15/2024
3			NO	12/17/2023	12/22/2023
4			YES	12/25/2024	1/2/2024
5			YES	1/15/2024	1/25/2024
6			NO	12/2/2023	12/27/2023
Sheet1

 

[Fluff]

What version of Excel are you using?

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)


How about

=IF(AND(L2<=$J$2,M2>=$I$2),"Yes","No")

 

[Utradeshow]

Yes Sir! I believe that did it, Thank you so much!

 

[Fluff]

Glad we could help & thanks for the feedback.

 

[kvsrinivasamurthy]

In C2

=IF(MEDIAN($D2,$B$2,$E2)>MEDIAN($A$2,$E2,$D2),"YES","NO")

 

[Fluff]

@kvsrinivasamurthy if you are going to changes the ranges (rather than use what has been posted) it would help if you actually posted a sample of data using XL2BB. That way it is clear what is in those cells.

 

[kvsrinivasamurthy]

@Fluff
I have changed the formula

=IF(MEDIAN($J$2,$L2,$M2)>MEDIAN($I$2,$L2,$M2),"YES","NO")