Wednesday, May 23, 2018

yogi_List Dates For Specified WeekDay Starting From A Given Day For Specified Number Of Weeks

Google Spreadsheet   Post  #2448

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     May-23-2018

question by: Colin TheWilson!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