yogi_Compute Ship Date Art Prep Date For Domestic And International

Google Spreadsheet   Post  #2269

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     Oct-13-2017

question by: Kimberlygeorge

https://productforums.google.com/forum/?utm_medium=email&utm_source=ba_notification#!topic/docs/j_HHWV8uL0k;context-place=mydiscussions

add days to a date based on a cell being selected
How can I have Google forms take an event date that is listed in one cell, and subtract a fixed number of days to that date based on whether 1 of 2 cells are checked?  If one cell is checked i need it to subtract 6 days, and if another cell is checked I need it to subtract 14 days into another column and put that date in the "ship date" box  Is this possible?

EVENT DATE	DOM - 6 days	INT'L -14 days	SHIP DATE
10/10/2017		x	9/15/2017
10/10/2017		x	9/26/2017
10/10/2017	X		10/2/2017

I manually did what I want google sheets to do?

Is this possible

---

Thank you so much for helping me, I am new to google forms.  The event date is 10/10/17 so I will need to ship 6 days prior so it should be, oops I had the original number of days as 8, and then changed it to 6. Sorry it should be 10/4/17.  And to add to it the complexity the ship date can not land on a weekend.  If 6 days prior lands on a weekend, we need to move it to the Friday before.  The 6 days should count weekends but we do not ship on weekends.  Thank you again for your help;