Condiction formule if date in rage

[webdevptg]

I have begin date in B2 cell and end dae in a cell C2. I want to obtain the value yes, if the begin date is between the 18th of the previous month and the 17th of the month of the end date. The verify end date is the 29th of the month.

Example:

I've tried several ways, but it never validates all the possibilities


Can you help me?

 

[dreid1011]

Edit: suggested formula was not quite right.

Edit: Try this:

Book1 1-25-2024.xlsm
	B	C	D
1	Begin Date	Finish Date
2	12/18/2023	1/28/2024	Yes
3	12/18/2023	1/29/2024	Yes
4	12/18/2023	1/30/2024	Yes
5	12/15/2023	1/18/2024	Yes
6	12/15/2023	12/28/2023	Yes
7	1/15/2024	1/28/2024	Yes
8	1/15/2024	1/30/2024	Yes
Sheet12

Cell Formulas
Range	Formula
D2:D8	D2	=IF(AND(B2>DATE(YEAR(EDATE(B2,-1)),MONTH(EDATE(B2,-1)),18),B2<DATE(YEAR(C2),MONTH(C2),17)),"Yes","No")

 

[webdevptg]

hI!
Formula in cells D4; D5 and D8

This is partially correct, the formulas in the cells D4; D5 and D8 cells must, return the value in the no

• D4 - Finish date is greather than 1/29/2024
• D5 - Finish date is greather than 12/29/2023
• D8 - Finish date is greather than 1/29/2024

 

[dreid1011]

I have begin date in B2 cell and end dae in a cell C2. I want to obtain the value yes, if the begin date is between the 18th of the previous month and the 17th of the month of the end date. The verify end date is the 29th of the month.

hI!
Formula in cells D4; D5 and D8

This is partially correct, the formulas in the cells D4; D5 and D8 cells must, return the value in the no

• D4 - Finish date is greather than 1/29/2024
• D5 - Finish date is greather than 12/29/2023
• D8 - Finish date is greather than 1/29/2024

You didn't say how the "verify end date" affects the outcome... the only conditions you supplied are these:

"begin date is between the 18th of the previous month and the 17th of the month of the end date."

And D5 (12/28/2023) is NOT greater than 12/29/2023.. at least not by your sample data.

Please explain how the 29th of the month should affect the result.