Excel - formula help needed
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. |
Excel - formula help needed
Does this help
=IF(date_of_hire<DATE(YEAR(TODAY()),1,1),52,52-WEEKNUM(date_of_hire)) -- HTH Bob Phillips (remove nothere from the email address if mailing direct) "GimmeStars" wrote in message ... 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. |
All times are GMT +1. The time now is 02:13 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com