Academy ↓
Create Tab For Every Day of the Year
Creates a new tab for every day of the year.
function myFunction() {
var date = new Date(2025,0,1)
while (date.getFullYear() === 2025){
const sheetName = Utilities.formatDate(date,"GMT+6",'MMM d')
SpreadsheetApp.getActiveSpreadsheet().insertSheet(sheetName)
date.setDate(date.getDate()+1)
}
}