| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel - remaining wks in a year formula
Help please!! I am finalizing a payroll accrual file and would love it if
there was a way to speed up this process every year. Does any know the formula to get the remaining weeks in a year based on various date fields? In other words... an employee accruing his 1st 40hrs of vacation would be... Emp#123(A1) started on 7/1/05 (A2) - therefore, his specific rate of accrual ..769231 (A3) would be calculated by the remaining weeks 26 (A4) in the year. What formula can I use to find (A4) based on date of hire (A2) and 52 weeks in a year? Anyone's help would be greatly appreciated!! Have a great day peeps. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help! How do you get excel to find the x(changes daily, marked in a cell from another formula) highest numbers in a group of numbers and sum them up? | Excel Worksheet Functions | |||
| How can i get an If formula in excel to edit another cell? | Excel Worksheet Functions | |||
| converting formula from lotus.123 to excel | Excel Worksheet Functions | |||
| Excel 97 - Adding Every 8th Row - Formula should work, but doesn't | Excel Worksheet Functions | |||
| How do I view the actual numeric value of a formula in Excel 2002. | Excel Worksheet Functions | |||
Threaded Mode
