Date Add and Subtract 7 CRX for Google Sheets
A Free Productivity Add-on
Published By developers.google.com/apps-script
Date Add and Subtract (mhdmhddjinipgjhpicaidhpimlmgnflb): Provides two custom functions for easily adding and subtracting time from a date value.... Read More > or Download Now >
Date Add and Subtract for Google Sheets
Tech Specs
- • Type: Google Sheets Add-on
- • Latest Version: 7
- • Price: Freeware
- • Offline: No
- • Developer: developers.google.com/apps-script
User Reviews
- • Rating Average
- 2.8 out of 5
- • Rating Users
- 99
Download Count
- • Total Downloads
- 6
- • Current Version Downloads
- 6
- • Updated: November 19, 2015
Date Add and Subtract is a free Productivity Add-on for Google Sheets. You could download the latest version crx file and install it.
More About Date Add and Subtract
Examples:
Adds 3 months to the date in cell A1.
=DATEADD(A1, "months", 3)
Subtracts 12 weeks from the date in cell A1.
=DATESUBTRACT(A1, "w", 12)
Adds 2 days to the dates in the range A1:A10.
=DATEADD(A1:A10, "day", 2)
This add-on was created as a sample for other developers to learn from. The complete Apps Script source code is available here: https://github.com/google/google-apps-script-samples/tree/master/date_add_and_subtract
Adds 3 months to the date in cell A1.
=DATEADD(A1, "months", 3)
Subtracts 12 weeks from the date in cell A1.
=DATESUBTRACT(A1, "w", 12)
Adds 2 days to the dates in the range A1:A10.
=DATEADD(A1:A10, "day", 2)
This add-on was created as a sample for other developers to learn from. The complete Apps Script source code is available here: https://github.com/google/google-apps-script-samples/tree/master/date_add_and_subtract
