should help you out If I understand you correctly, you want to return a period name (e.g. <3 Days, 4-7 Days, or 8-14 Days, etc.) in Column D based on the Days Count. If so, you can use the approximate match of VLOOKUP to achieve that, but you will need to create a look up table first. See below screen-shot for details. Please note I have named the look up table as Tbl_Period in my solution.
Formula that counts days worked while excluding overlapping or partial overlapping days in Google Sheets
it should still fix some issue I'm attempting to create a schedule that counts the number of days an employee has worked while ignoring the days that overlap. I have a spreadsheet with all employee activities that gets populated dynamically. Some of these activities overlap, some of them partially overlap. It seems like everything I tried today by searching through forums doesn't account for