i want to do it autofill

[ucif]

Hi, i tried to make a full excel autofill sheet , now i'm at 60% of this work, it's kind of salary to fill and give it to the other co worker to add sums but what i want it's little hard
i have to give the name of worker, first name and last name , the birthday and birthplace ..so i can do this in pdf exchange , i want to make it in excel but this isn't my problem , my problem i want to make an autofill to the years and days month the worker serve in our company
example from 10/10/1980 to 7/2/1985

1980 | 10/10| 31/12| 52 days
1981 |01/01 | 31/12|365 days
1982| 01/01 | 31/12|365 days Ps: every year must be 365 not 364 or 366 days
1983|01/01 | 31/12|365 days
1984|01/01 | 31/12|365 days
1985|01/01 | 7/2| 37 days

so i want to make an excel calculator when i put 10/10/1982 --> 07/02/1985 he will just make me this chart end at the 07/02/1985


so i add the excel file and the pdf picture ..so please help me , my shoulder hurt when i write a lot of people with calculation

also some people have a two years serve at Army example

example from 10/10/1980 to 7/9/1985 and Army serve :01/06/1983 to 01/06/1985

1980 | 10/10| 31/12| 52 days
1981 |01/01 | 31/12|365 days
1982| 01/01 | 31/12|365 days Ps: every year must be 365 not 364 or 366 days
1983|01/01 | 30/05| 126 days
1983 |01/01| 31/12| Army
1984|01/01 | 31/12| Army
1985|01/01 | 30/05| Army
1985 |01/06| 7/9| 98 days

tableaux retraite.xlsx
	A	B	C	D	E	F	G	H	I
1
2
3
4
5
6
7		1983	2/11	31/12	59 Jours
8		1984	1/1	31/12	365 Jours
9		1985	1/1	31/12	365 Jours
10		1986	1/1	15/1	15 Jours
11		1986	16/1	31/12	S.N
12		1987	1/1	31/12	S.N
13		1988	1/1	15/1	S.N
14		1988	16/1	31/12	351 Jours
15		1989	1/1	31/12	365 Jours
16		1990	1/1	31/12	365 Jours
17		1991	1/1	31/12	365 Jours
18		1992	1/1	1/9	244 Jours
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
PAR JOURS

Cell Formulas
Range	Formula
E18,E7:E8	E7	=(D7-C7)*1&" Jours"
E14:E17,E9:E10	E9	=(D9-C9)+1*1&" Jours"