Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- function datum(){
- var ss = SpreadsheetApp.getActiveSpreadsheet();
- var sheet = ss.getSheetByName('Master');
- var getDatum = sheet.getRange("C4").getValue();
- var date = new Date(getDatum); // MM/DD/YYYY
- date.setDate(date.getDate()+1);
- var dateStr = date.getDay()+'/'+(date.getMonth()+1)+'/'+date.getFullYear();
- var setDatum = sheet.getRange("W3");
- setDatum.clear();
- setDatum.setValue(dateStr);
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement