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.

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"


On Jun 13, 2:23*pm, ad2ad79 wrote:
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.

On Jun 13, 3:08*pm, muddan madhu wrote:
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"

On Jun 13, 2:23*pm, ad2ad79 wrote:



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.- Hide quoted text -

- 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

On Jun 13, 3:08*pm, muddan madhu wrote:
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"

On Jun 13, 2:23*pm, ad2ad79 wrote:



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.- Hide quoted text -

- Show quoted text -

Hi Madan ..

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

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"


--
barry houdini
------------------------------------------------------------------------
barry houdini's Profile: http://www.thecodecage.com/forumz/member.php?userid=72
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=106334