Using DATEDIF with multiple date criteria

[Lstone1]

Is there a formula that will allow me to count days between a start date and end date if those days fall within another date range ? For example
Start Date=11/1/22 End Date=12/12/23.
I want a formula that will return the number of days between these 2 dates only if the days are between 10/1/22-9/30/23.
Thanks for the help!

 

[Eric W]

Welcome to the MrExcel forum!

Try:

Book1 (version 1).xlsb
	A	B	C	D	E	F	G	H	I
1							FY 2023	10/1/2022	9/30/2023
2	Start Date	End Date	Days in 23	Days in 24			FY 2024	10/1/2023	9/30/2024
3	11/1/2022	12/12/2023	333	72
Sheet11

Cell Formulas
Range	Formula
C3	C3	=MAX(0,MIN($B$3,I1)-MAX($A$3,H1))
D3	D3	=MAX(0,MIN($B$3,I2)-MAX($A$3,H2))

 

[BobsterT]

Following the same type problem,
I want the number of days in an hotel between the range in cell B2 en C2.
The result should be in column D.
Anyone can help me on this?

 

[Eric W]

Welcome to the MrExcel forum!

For future reference, it's better to open a new thread when you have a question. Quite often no one will see if you add a post to the end of the existing thread.

As far as your question, try this in D5:

=IF(C5<=B5,"Error",C5-B5-1)