Advertisement
Guest User

Untitled

a guest
Feb 20th, 2017
84
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.44 KB | None | 0 0
  1. function datum(){
  2. var ss = SpreadsheetApp.getActiveSpreadsheet();
  3. var sheet = ss.getSheetByName('Master');
  4. var getDatum = sheet.getRange("C4").getValue();
  5. var date = new Date(getDatum); // MM/DD/YYYY
  6. date.setDate(date.getDate()+1);
  7. var dateStr = date.getDay()+'/'+(date.getMonth()+1)+'/'+date.getFullYear();
  8. var setDatum = sheet.getRange("W3");
  9. setDatum.clear();
  10. setDatum.setValue(dateStr);
  11. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement