i want to do it autofill

ucif

New Member
Joined
Apr 7, 2022
Messages
1
Office Version
  1. 2021
  2. 2007
Platform
  1. Windows
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
ABCDEFGHI
1
2
3
4
5
6
719832/1131/1259 Jours
819841/131/12365 Jours
919851/131/12365 Jours
1019861/115/115 Jours
11198616/131/12S.N
1219871/131/12S.N
1319881/115/1S.N
14198816/131/12351 Jours
1519891/131/12365 Jours
1619901/131/12365 Jours
1719911/131/12365 Jours
1819921/11/9244 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
RangeFormula
E18,E7:E8E7=(D7-C7)*1&" Jours"
E14:E17,E9:E10E9=(D9-C9)+1*1&" Jours"
 

Excel Facts

How to total the visible cells?
From the first blank cell below a filtered data set, press Alt+=. Instead of SUM, you will get SUBTOTAL(9,)

Forum statistics

Threads
1,213,535
Messages
6,114,194
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top