With almost universal availability of Internet and the availability of reliable on-line productivity tools, such as Google Docs, individuals as well as companies are switching over to Cloud Computing. In this blog I will post items of interest to my colleagues/patrons/clients.
Wednesday, July 4, 2018
yogi_From 1st of the Month and Year Compute Week Nos for The Month And Year
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)
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.