End of service and vacation days

[shanghity]

Dear members.

I have an employee start working for 01/01/2014 to 21/11/2017 = 3 years, 10 months, 20 days.

And he has unpaid vacation = 1 year, 11 months, 25 days.

How can I reduce unpaid vacation from the total of working time, to give me a net working time?

I hope my explaining is good.

Thank you all.

 

[stigcorneer]

Do you use a standard month of 30 days?

 

[shanghity]

Do you use a standard month of 30 days?

Yes.

 

[stigcorneer]

Try this:
E11:=ROUNDDOWN(((E9-E10)*360+(D9-D10)*30+C9-C10)/360;0)
D11:=ROUNDDOWN(MOD(((E9-E10)*360+(D9-D10)*30+C9-C10);360)/30;0)
C11:=MOD(MOD(((E9-E10)*360+(D9-D10)*30+C9-C10);360);30)

 

[shanghity]

Try this:
E11:=ROUNDDOWN(((E9-E10)*360+(D9-D10)*30+C9-C10)/360;0)
D11:=ROUNDDOWN(MOD(((E9-E10)*360+(D9-D10)*30+C9-C10);360)/30;0)
C11:=MOD(MOD(((E9-E10)*360+(D9-D10)*30+C9-C10);360);30)

Thank you very much.
That exactly what I need.