Posted by John Franklin on November 15, 2001 6:30 PM
We process Disability Claims. We need to find the specific days within a given period that an employee should be paid. We want to be able to enter the first and last dates of payment and have a formula in Excel that can tell us the number of days the employee should be paid within those two dates depending upon what days of the week they normally work. For example, if an employee works Mon, Wed, Fri and the period within the two dates adds up to 3 weeks the program should be able to tell us that we need to pay this individual for nine days. The reason we ask is because we process hundreds of claims a week. Please help.