YEAR MONTH DAYS COUNTER

  • Thread starter Thread starter ad2ad79
  • Start date Start date
A

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.
 
Can't you just use
=dateleave-datejoin-absentdays
If desired, send your file to my address below along with this msg and a
clear explanation of what you want and before/after examples.
 
You have posted to several groups. This is NO way to win friends. Post in
ONE group or you waste our time.
 
Back
Top