Is there a formula to count the number of weeks in...
# general
b
Is there a formula to count the number of weeks in a saved search date range? I'm trying to build a search to see who is missing weekly timesheets that are imported from our time tracking system. I have a date range on the criteria of Weekly Start Date within last rolling half. I want to find a way to count the number of weeks in that range and compare it to the number of the employee's timesheets in that same range. I've got the number of timesheets, just stuck on figuring out how/if I can compare it to the number of weeks in that range.