I am trying to accomplish two things here.
1) Conditional Formatting
- So if a date is = to another date or is + 7 days after, than it will be green, if not then red. (trying to include a picture, but it's not uploading, I will do my best to explain!)
if i have two dates:
date 1 (cell E119) : 9/9/19
Date 2(cell F119) : 9/10/19
I want that second date to be green if its equal to "date 1" or within a 7 day range after that
Hope that makes sense
2) sumif
To get to my next part, there are many work arounds that I know will work to get to the answer, but I feel like SumIf is the best option here.
So, if that cell is green, I want to add the revenue associated with that date. + the revenue I have on another tab.
I would connect these two data sets through a unique ID. Not sure if that is helpful here.
Bookmarks