What I would like to do is to create a script or with a function that will add automatically the day, the month and the year per row for 4 years for example in order to make a calendar of shooting, pre production and post prod per film. It would be so long to do it manually and add each day per month for 4 or more years. If it’s done by a script it would be done instantly and would be possible to update later to add more years.
Example of what I’m looking for
If it’s too complicated per day, I can add per week. Like week 1 January 21, just like in the picture. But I really prefer if that’s possible to add a row per day to be the most accurate as possible.
Advertisement
Answer
Days for the rest of the year in a column
function daysforrestofyear() { let days = []; let dt = new Date(); const ldtv = new Date(dt.getFullYear() + 1,0,1).valueOf(); do { days.push([Utilities.formatDate(dt,Session.getScriptTimeZone(),"dd/MMM/yyyy")]); dt.setDate(dt.getDate() + 1); }while(dt.valueOf() < ldtv) const ss = SpreadsheetApp.getActive(); const sh = ss.getSheetByName("Sheet0"); sh.clearContents(); sh.getRange(1,1,days.length,1).setValues(days); }
Jun/04/2022 |
---|
Jun/05/2022 |
Jun/06/2022 |
Jun/07/2022 |
Jun/08/2022 |
Jun/9/2022 |
Jun/10/2022 |
Jun/11/2022 |
Jun/12/2022 |
Jun/13/2022 |
Jun/14/2022 |
Jun/15/2022 |
Jun/16/2022 |
Jun/17/2022 |
Jun/18/2022 |
Jun/19/2022 |
Jun/20/2022 |
Jun/21/2022 |
Jun/22/2022 |
Jun/23/2022 |
Jun/24/2022 |
Jun/25/2022 |
Jun/26/2022 |
Jun/27/2022 |
Jun/28/2022 |
Jun/29/2022 |
Jun/30/2022 |
Jul/01/2022 |
Jul/02/2022 |
Jul/03/2022 |
Jul/04/2022 |
Jul/05/2022 |
Jul/06/2022 |
Jul/07/2022 |
Jul/08/2022 |
Jul/9/2022 |
Jul/10/2022 |
Jul/11/2022 |
Jul/12/2022 |
Jul/13/2022 |
Jul/14/2022 |
Jul/15/2022 |
Jul/16/2022 |
Jul/17/2022 |
Jul/18/2022 |
Jul/19/2022 |
Jul/20/2022 |
Jul/21/2022 |
Jul/22/2022 |
Jul/23/2022 |
Jul/24/2022 |
Jul/25/2022 |
Jul/26/2022 |
Jul/27/2022 |
Jul/28/2022 |
Jul/29/2022 |
Jul/30/2022 |
Jul/31/2022 |
Aug/01/2022 |
Aug/02/2022 |
Aug/03/2022 |
Aug/04/2022 |
Aug/05/2022 |
Aug/06/2022 |
Aug/07/2022 |
Aug/08/2022 |
Aug/9/2022 |
Aug/10/2022 |
Aug/11/2022 |
Aug/12/2022 |
Aug/13/2022 |
Aug/14/2022 |
Aug/15/2022 |
Aug/16/2022 |
Aug/17/2022 |
Aug/18/2022 |
Aug/19/2022 |
Aug/20/2022 |
Aug/21/2022 |
Aug/22/2022 |
Aug/23/2022 |
Aug/24/2022 |
Aug/25/2022 |
Aug/26/2022 |
Aug/27/2022 |
Aug/28/2022 |
Aug/29/2022 |
Aug/30/2022 |
Aug/31/2022 |
Sep/01/2022 |
Sep/02/2022 |
Sep/03/2022 |
Sep/04/2022 |
Sep/05/2022 |
Sep/06/2022 |
Sep/07/2022 |
Sep/08/2022 |
Sep/9/2022 |
Sep/10/2022 |
Sep/11/2022 |
Sep/12/2022 |
Sep/13/2022 |
Sep/14/2022 |
Sep/15/2022 |
Sep/16/2022 |
Sep/17/2022 |
Sep/18/2022 |
Sep/19/2022 |
Sep/20/2022 |
Sep/21/2022 |
Sep/22/2022 |
Sep/23/2022 |
Sep/24/2022 |
Sep/25/2022 |
Sep/26/2022 |
Sep/27/2022 |
Sep/28/2022 |
Sep/29/2022 |
Sep/30/2022 |
Oct/01/2022 |
Oct/02/2022 |
Oct/03/2022 |
Oct/04/2022 |
Oct/05/2022 |
Oct/06/2022 |
Oct/07/2022 |
Oct/08/2022 |
Oct/9/2022 |
Oct/10/2022 |
Oct/11/2022 |
Oct/12/2022 |
Oct/13/2022 |
Oct/14/2022 |
Oct/15/2022 |
Oct/16/2022 |
Oct/17/2022 |
Oct/18/2022 |
Oct/19/2022 |
Oct/20/2022 |
Oct/21/2022 |
Oct/22/2022 |
Oct/23/2022 |
Oct/24/2022 |
Oct/25/2022 |
Oct/26/2022 |
Oct/27/2022 |
Oct/28/2022 |
Oct/29/2022 |
Oct/30/2022 |
Oct/31/2022 |
Nov/01/2022 |
Nov/02/2022 |
Nov/03/2022 |
Nov/04/2022 |
Nov/05/2022 |
Nov/06/2022 |
Nov/07/2022 |
Nov/08/2022 |
Nov/9/2022 |
Nov/10/2022 |
Nov/11/2022 |
Nov/12/2022 |
Nov/13/2022 |
Nov/14/2022 |
Nov/15/2022 |
Nov/16/2022 |
Nov/17/2022 |
Nov/18/2022 |
Nov/19/2022 |
Nov/20/2022 |
Nov/21/2022 |
Nov/22/2022 |
Nov/23/2022 |
Nov/24/2022 |
Nov/25/2022 |
Nov/26/2022 |
Nov/27/2022 |
Nov/28/2022 |
Nov/29/2022 |
Nov/30/2022 |
Dec/01/2022 |
Dec/02/2022 |
Dec/03/2022 |
Dec/04/2022 |
Dec/05/2022 |
Dec/06/2022 |
Dec/07/2022 |
Dec/08/2022 |
Dec/9/2022 |
Dec/10/2022 |
Dec/11/2022 |
Dec/12/2022 |
Dec/13/2022 |
Dec/14/2022 |
Dec/15/2022 |
Dec/16/2022 |
Dec/17/2022 |
Dec/18/2022 |
Dec/19/2022 |
Dec/20/2022 |
Dec/21/2022 |
Dec/22/2022 |
Dec/23/2022 |
Dec/24/2022 |
Dec/25/2022 |
Dec/26/2022 |
Dec/27/2022 |
Dec/28/2022 |
Dec/29/2022 |
Dec/30/2022 |
Dec/31/2022 |