Enumeration of dates between 'startdate' and 'enddate' using Custom function
frequently working schedule
we need to view dates between startdate and enddate.
we can extract dates from working duration without adding any repeated codes.
[script]
function dtr( formula ){
if (typeof formula.map === "function"){
return formula.map(dtr);
}else if(formula){
return WriteTermDates(formula);
}
}
function WriteTermDates(d) {
var ss1 = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("SHEET");
var testDate = new Date("1900/1/1");
var startDate = new Date(testDate.getDate()+parseInt(d.substring(0,5)-25569)24 * 60 * 60 * 1000);
var endDate = new Date(testDate.getDate()+parseInt(d.substring(5,10)-25569)24 * 60 * 60 * 1000);
var values = "";
while(startDate.getDate() <= endDate.getDate()) {
// Logger.log(Utilities.formatDate(startDate, "GMT", "MM-dd"));
values += Utilities.formatDate(startDate, "GMT", "MM-dd") + ", ";
startDate.setDate(startDate.getDate() + 1);
}
return values;
}