I want a formula to lookup a date, establish whats it falls onto using the week ending date, match that against the employee name and return the intersecting value.
For example, I want to see James' potential hours for 8/1/21, which should return 32 (B16). If the date was 04/04/21 then it...