Wednesday, July 4, 2018

yogi_From 1st of the Month and Year Compute Week Nos for The Month And Year

Google Spreadsheet   Post  #2472

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

question by: docuser8374!topic/docs/acihFR1nFuw;context-place=forum/docs
List Week numbers and dates per month (each month on a separate sheet)
Hi Folks,

I'm wondering if it's possible to do a couple of date-related things in Google Sheets.

1. Get the first row of each needed column to auto-populate depending on the A1 cell's month. 
For example, if I wrote "July, 2018" in cell A1...
Cell B1 would automatically populate to "Week 1 (7/2/2018 - 7/8/2018)"
Cell C1 would automatically populate to "Week 2 (7/9/2018 - 7/15/2018)"
and so on.

For some months there would be 4 of these 'weeks columns,' others will have 5 - as necessary

2. Auto Copy the form above to 12 sheets - 1 for each month - in the document. 
Each sheet should have the subsequent month filled in. 
So if the month in A1 in Sheet 1 is "July, 2018", it should populate as "August, 2018" in A1 in sheet 2, "September, 2018" in A1 in sheet 3, etc etc.