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
https://productforums.google.com/forum/?utm_medium=email&utm_source=ba_notification#!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.