Friday, October 13, 2017

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 DATEDOM - 6 daysINT'L -14 daysSHIP DATE
10/10/2017x9/15/2017
10/10/2017x9/26/2017
10/10/2017X10/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;