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?
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
------------------------------------------------------------------------------------------------------------------------------------
No comments:
Post a Comment