Hello, I am going to try to explain this to the best of my ability, please reach out if anything seems confusing. In column A (labeled Internal A), I have a list of dates that are Sundays. In column B, I have counts of numbers associated with that specific Sunday date. In Column D, I have Monday dates (except for the holiday which is on a Tuesday) that are labeled (External B) and I have counts associated with that date in Column E. In Column N (Final Date) are the results that I desire and the counts Column O associated with them.
What I would like my end result to be in Columns N and O are the following:
I would like to have a list of all of the internal dates +1 and a list of the external dates as well. For example, Cell A11 has a date of 05/23/2021 with a count of 86. In column H, I would like to add a +1 to that 05/23/2021 date (Cell A11) which would make it 05/24/2021 which is already in Cell D3 for the external date. For the final total count (column N) it would be 05/24/2021 with a count of 90 in Column O (86 for 05/23 + 4 for 05/24).
The problem that I have is highlighted. On Column D, Cell D10, there is a date 0f 09/27/2021 and b/c there is no 09/26/2021 on Column A, it would not populate with the formula that I am using. I would like to still use that date, even if it the previous date is not in Column A.
*Below is a bonus if that is possible* If the date is a holiday 07/04/2021, I would like it to go to the next date of 07/06/2021 as a final date and count of 4. So the final date would be 07/06/2021 with a count of 4 (1 from 07/04 and 3 from 07/06).
Any assistance would be greatly appreciated. Please see attachment.