Google Spreadsheet Post #2448
Yogi Anand, D.Eng, P.E. ANAND Enterprises LLC -- Rochester Hills MI May-23-2018
question by: Colin TheWilson
https://productforums.google.com/forum/#!topic/docs/8iyQlLwxcxs;context-place=forum/docs
Increment dates
Hello! I'd like to know a way to increment dates based on the start of the week.
For example, I want to make a series of column headings that say "Week of 5/1", "Week of 5/7", "Week of 5/14", "Week of 5/21", "Week of 5/28".
I'm going to do this on a large scale (A new set of headings every month for many years), so I want to have a function that would only take the month and would auto-generate the week start headings.
Is something like this possible? Thanks!
No comments:
Post a Comment