YEAR MONTH DAYS COUNTER

[ad2ad79]

Hi,
I have a sheet in which I want to count the year then month and then
days for employee. i.e

Name Date of joining Date of leaving ABSENT DAYS TOTAL
JOHN 23-08-2001 11-11-2008 15
Years-Months-Days


I want that Function or formula count first Rounded Year from
23-08-2001 23-08-2008 then count Month and then days. and then minus
Absent days and final result. Pls help me.

 

[muddan madhu]

try this assumed date of joining in cell B2 , date of leaving in cell
C2 and Absent days in D2

=INT((C2-B2)/365)&" Years ,"&INT(MOD((C2-B2)/365,1)*12)&" Months ,"&INT
((((C2-B2)/365)*12)*31)-INT(MOD((C2-B2)/365,1)*12)*31-D2&" Days"

 

[ad2ad79]

try this assumed date of joining in cell B2 , date of leaving in cell
C2 and Absent days in D2

=INT((C2-B2)/365)&" Years ,"&INT(MOD((C2-B2)/365,1)*12)&" Months ,"&INT
((((C2-B2)/365)*12)*31)-INT(MOD((C2-B2)/365,1)*12)*31-D2&" Days"





- Show quoted text -

NO.... It doesn't work... just try at ur end.... it doesn't show the
right result.... pls do send me the correct one
thanks

 

[ad2ad79]

try this assumed date of joining in cell B2 , date of leaving in cell
C2 and Absent days in D2

=INT((C2-B2)/365)&" Years ,"&INT(MOD((C2-B2)/365,1)*12)&" Months ,"&INT
((((C2-B2)/365)*12)*31)-INT(MOD((C2-B2)/365,1)*12)*31-D2&" Days"





- Show quoted text -

Hi Madan ..

If u calculate urself manually.. U c... Year and month calculate
correctly.. but..... days r not calculating correctly..

 

[barry houdini]

What result do you expect for that example?

Try using DATEDIF, i.e. this formula

=DATEDIF(B2,C2-D2,"y")&" years "&DATEDIF(B2,C2-D2,"ym")&" months
"&DATEDIF(B2,C2-D2,"md")&" days"

for your example that will give "7 years 2 months 4 days"