Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
VACCRUED VACATION / DISPLAYED
I AM TRYING TO DISPLAY THE CURRENT MONTH OF ACCRUED VACATION.
EXAMPLE: ACCRUED VACATION TIME 01/01/08 02/01/08 21.32 02/01/08 03/01/08 22.15 03/01/08 04/01/08 22.98 04/01/08 05/01/08 23.82 05/01/08 06/01/08 24.65 i HAVE CREATED A SUMMARY TAB WICH SHOULD DISPLAY THE CURRENT ACCRUED VACATION TIME FOR A SPECIFIC EMPLOYEE. I'M LOOKING FOR A FORMULA TO USE. THAT WILL ALWAYS DISPLAY THE ACCRUED VACATION TIME IN REFERENCE TO TOAYS DATE. SHOULD I USE AN =IF STATEMENT. EXAMPLE: =IF(C33)TODAY() THIS IS AS FAR AS i AM GETTING AT THE MOMENT. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
vacation with accural | Setting up and Configuration of Excel | |||
vacation schedule | Charts and Charting in Excel | |||
Vacation planner | Excel Discussion (Misc queries) | |||
Vacation Pay Calculation | Excel Discussion (Misc queries) | |||
Vacation | Excel Worksheet Functions |