Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Employee Turnover
We are trying to devise a spreadsheet to track our monthly gain/losses in
addition to calcuating days worked if they were hired within the year. Here is our spreadsheet - open to anything however that may make this easier: A1 - Name B1 - Company C1 - Date of Hire D1 - Company E1 - Reason for Leaving F1 - Date left company G1 - Actual days employed The result in G1 we want locate a match in A1, retrieve date of hire in C1, subtract day left in F1 and return result of days worked In addition, if a pivot table could be created, that would be a bonus! Any help is appreciated Thanks! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Employee Turnover
In G2, put this formula and copy down as far as you have data in column
A......... =F1-C1 And format G2 as General...........then do Data Filter Autofilter, and select a name from the dropdown in column A......... HTH Vaya con Dios, Chuck, CABGx3 "S in AZ" wrote in message ... We are trying to devise a spreadsheet to track our monthly gain/losses in addition to calcuating days worked if they were hired within the year. Here is our spreadsheet - open to anything however that may make this easier: A1 - Name B1 - Company C1 - Date of Hire D1 - Company E1 - Reason for Leaving F1 - Date left company G1 - Actual days employed The result in G1 we want locate a match in A1, retrieve date of hire in C1, subtract day left in F1 and return result of days worked In addition, if a pivot table could be created, that would be a bonus! Any help is appreciated Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Employee Tracking | Excel Worksheet Functions | |||
employee schedule | Excel Discussion (Misc queries) | |||
Calculate employee hours for employee evaluation? | Excel Worksheet Functions | |||
Fromula to take employee # out of employee name field | Excel Discussion (Misc queries) | |||
employee scheduling | Excel Worksheet Functions |