Zobacz posty bez odpowiedzi | Zobacz aktywne tematy RSSKanał RSS



Odpowiedz  [ 1 post ] 
 Excel Formula Regarding IF statements & Work days 
Autor Wiadomość

Rejestracja: 10 Maj 2017, 08:23
Posty: 260
Post Excel Formula Regarding IF statements & Work days
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.





You can check this 2D Character Video


17 Lip 2017, 08:31
Profil
Wyświetl posty z poprzednich:  Sortuj według  
Odpowiedz   [ 1 post ] 

Nie możesz zakładać nowych tematów na tym forum
Nie możesz odpowiadać w tematach na tym forum
Nie możesz edytować swoich postów na tym forum
Nie możesz usuwać swoich postów na tym forum
Nie możesz dodawać załączników na tym forum

Szukaj:
cron
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group.
Designed by STSoftware for PTF.

phpBB SEO