Hi.
I have an excel spreadsheet that is currently showing all open orders per retailers. The last 6 columns show: Todays date, and then the next working day, next working day, etc. The last column is anything after the "fourth" date past todays date.
So below the dates I have x's that are to fill themselves in, regarding the correct dates. For example, I have an order that was received on 6/30/17, so the x would fall under the forth working day (not including the day it was received). Therefore the ship date would be 7/7 due to the holiday this week.
Can someone please help me with the crazy excel formula that I need to concoct to have the x's fall into the correct dates? I'm struggling.