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
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" |