Number of Days Between a Number of Days

[gr8whthunter76]

First, I can not believe how incredibly smart you all are on here. I am pretty good with excel.......I thought until I read what you all talk about and do, holy cow. I'm going to press my luck with 2 questions in one day. Your first solution worked swimmingly but now I have another hang up. In c2 I have 10/01/2016, d2 I have 09/30/2017, e2 09/01/2017, f2 04/30/2019. What I am looking for is the formula to figure out how many days from e2 to f2 fall between c2 and d2. In the next row I have c3 10/01/2017 d3 09/30/2018 and same in e2 and f2 but only now in e3 and f3. I tried to upload a picture or workbook and stupid work computer won't allow it. Hate this thing. If you can help, well I can't do anything other then say thank you!!!!!!

 

[jtakw]

Hi,

May be something like this:

Book3.xlsx
	C	D	E	F	G
2	10/1/2016	9/30/2017	9/1/2017	4/30/2019	29
3	10/1/2017	9/30/2018	9/1/2017	4/30/2019	364
Sheet767

Cell Formulas
Range	Formula
G2:G3	G2	=DAYS(MIN(D2,F2),MAX(C2,E2))

 

[gr8whthunter76]

Absolutely incredible, you are a gentleman and a scholar!

 

[jtakw]

You're welcome, thanks for the feedback.

In case you have dates in E:F that are Outside of C:D, as in my sample C4:F4 below, this version of my formula will produce a 0 result (rather than a negative):

Book3.xlsx
	C	D	E	F	G
2	10/1/2016	9/30/2017	9/1/2017	4/30/2019	29
3	10/1/2017	9/30/2018	9/1/2017	4/30/2019	364
4	10/1/2019	9/30/2020	9/1/2017	4/30/2019	0
Sheet767

Cell Formulas
Range	Formula
G2:G4	G2	=MAX(DAYS(MIN(D2,F2),MAX(C2,E2)),0)