YEAR MONTH DAYS COUNTER

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.
 
D

Don Guillett

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.
 
D

Don Guillett

You have posted to several groups. This is NO way to win friends. Post in
ONE group or you waste our time.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

YEAR MONTH DAYS COUNTER 4
YEAR MONTH DAYS COUNTER 8
Counting Unique Days based on multiple criteria 5
Formula to display Count of Days in given month, using list of Startand End Dates 2
count not-overlapping days in a "Table" with Beginning and EndingsDates Specified 0
number of months and days between two dates without approximation 3
Query to display the difference of period for an employee. 1
Summarise data by Month 7

Top