Sunday, December 11, 2016

yogi_For Dates In Column A Assign Weekday And 'Commenncing Week Of ' Day Number Of Monday of The Week

Google Spreadsheet   Post  #2094
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Dec-11-2016
question by:Mike Kn0tt:
https://productforums.google.com/forum/?utm_medium=email&utm_source=ba_notification#!topic/docs/8ZhMoUdMdvM;context-place=forum/docs

How to update the date, weekly?

I know how to update the date daily ( =today() ) but is there a way to do this but weekly? I know I can set up scripts to do different things on a weekly basis but can't think how I would do this to make it change weekly and not change the date daily in between.

To explain further, if I was to use =today() on Monday it would show Monday in the cell with the date. The next day it would change to Tuesday and so on. But what I would like is a similar function but to only change weekly. On Monday it would show week commencing 7th, Tuesday it would still show week commencing the 7th, same would go for Wednesday, etc. Until the following Monday where it would change to week commencing 14th.