Wednesday, August 20, 2014

yogi_For Dates In Column F Compute Corresponding Date For Specified Previous WeekDay

                       Google Spreadsheet   Post  #1731
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Aug-17-2014
post by Michael Gannon:
(https://productforums.google.com/forum/#!category-topic/docs/spreadsheets/gInrDI8Uw8U)
What formula would i use to change future dates to back date to its most previous friday?
Hey, everyone!! Would someone happen to know a formula that i could use that would change my future dates to fall back to a previous Friday...
H5 is referencing the date in F5, currently I've succumb to having to do it manually i.e cell H5  is =F5-3    and F5 is 9/1/2014
Any help would be awesome!! Thanks
------------------------------------------------------------------------------------------------------------------------------------