Find days between two dates

[adiles]

Dear All,

I am looking for a simple formula, which will display the number of days in a year. Kindly help me.

Name	DOJ	EOS	2013​	2014​	2015​
Employee 1	01-01-13​	08-08-15​	364​	364​	220​
Employee 2	05-04-14​	31-05-16​		270​	364​
Employee 3	15-02-14​	16-04-15​		319​	106​

 

[jasonb75]

Your expected answers are inconsistent, so this is what I think you want.

If it is not what you want then you will need to explain how you got your expected results.

Book1
	A	B	C	D	E	F
1	Name	DOJ	EOS	2013	2014	2015
2	Employee 1	01/01/2013	08/08/2015	365	365	220
3	Employee 2	05/04/2014	31/05/2016		271	365
4	Employee 3	15/02/2014	16/04/2015		320	106
Sheet1

Cell Formulas
Range	Formula
D2:F4	D2	=IFERROR(1/(1/MAX(0,MIN($C2,DATE(D$1,12,31))-MAX($B2,DATE(D$1,1,1))+1)),"")

 

[adiles]

Your expected answers are inconsistent, so this is what I think you want.

If it is not what you want then you will need to explain how you got your expected results.

Book1
	A	B	C	D	E	F
1	Name	DOJ	EOS	2013	2014	2015
2	Employee 1	01/01/2013	08/08/2015	365	365	220
3	Employee 2	05/04/2014	31/05/2016		271	365
4	Employee 3	15/02/2014	16/04/2015		320	106
Sheet1

Cell Formulas
Range	Formula
D2:F4	D2	=IFERROR(1/(1/MAX(0,MIN($C2,DATE(D$1,12,31))-MAX($B2,DATE(D$1,1,1))+1)),"")

Thanks Brother, I really appreciate your effort.