how to convert days to months, months to years ?

[inspectoRQ]

hello everyone,
Our worker works 15 years, 11 months, and 65 days. I want to convert them like 16 years,1
months, and 5 days. Because 65 days is 2 months and 5 days. I added it to 11 months. so it equals 1 year and 1 month. So the result is 16 years,1 month and 5 days.

 

[richh]

Hi inspecto,

Question - Do you happen to have the employees' start dates on file? If so, you can use a couple of different methods to track how long they've worked based upon the start date and a given date (like today)

Example of my data:

Formulas:

Year column: =YEAR(TODAY()) - YEAR(B2)
Month column: =IF(MONTH(TODAY())<MONTH(B2), 12-MONTH(B2) + MONTH(TODAY()), MONTH(TODAY())-MONTH(B2))
Days column: =IF(DAY(B2)>DAY(TODAY()), 31-DAY(B2)+DAY(TODAY()), DAY(TODAY())-DAY(B2))

 

[Crystalyzer]

Solutions 20210722.001.xlsm
	A	B	C	D	E
1
2			Years	Months	Days
3		Source	15	11	65
4		Result	16	1	5
Sheet2

Cell Formulas
Range	Formula
C4	C4	=C3+ROUNDDOWN((ROUNDDOWN((E3/30),0)+D3)/12,0)
D4	D4	=IF(ROUNDDOWN(E3/30,0)>0,IF(D3+ROUNDDOWN(E3/30,0)>=12,MOD(D3+ROUNDDOWN(E3/30,0),12),D3+ROUNDDOWN(E3/30,0)),IF(D3>=12,MOD(D3,12),D3))
E4	E4	=IF(E3>=30,MOD(E3,30),E3)

 

[inspectoRQ]

First of all, thank you so much for sparing time for me. I solved the problem like in added pic.

 

[inspectoRQ]

thank you to each of you individually, @richh, @Crystalyzer