| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
YEAR MONTH DAYS COUNTER
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Tell me which "season" (Month/Day through Month/Day) a date(Month/Day/Year) falls in (any year)??? | Excel Discussion (Misc queries) | |||
| Calc Prorated Cost based on Specific Days in a Given Month & Year Range (Revisited..) | Excel Discussion (Misc queries) | |||
| How do I set an automatic working days counter | Setting up and Configuration of Excel | |||
| To detect month or days or year in if formula | Excel Discussion (Misc queries) | |||
| Month Counter | Excel Worksheet Functions | |||
Threaded Mode
