TAPS_MikeDion
Well-known Member
- Joined
- Aug 14, 2009
- Messages
- 629
- Office Version
- 2011
- Platform
- MacOS
Happy New Year's Eve to everyone!
I'm sure this will be an easy one for those of you who know the Google Sheets Apps Script language.
All I was hoping to do is have the date in cell A2, which is selected by using data validation as a drop-down calendar (this is already set up), be reduced by 14 days when the image is clicked or increased by 14 days when the image is clicked. I realize this will require 1 script for each function.
For example:
1. The date is set via the drop-down calendar in A2 to 12/28/24
2. Clicking the changes (reduces) the date in cell A2 to 12/14/24
- OR-
3. Clicking the changes (increases) the date in cell A2 to 1/11/24
I'm all set with knowing how to assign the scripts to the images, it's just the script code for the date changes that I'm not getting right.
Thank you to anyone offering to assist!
I'm sure this will be an easy one for those of you who know the Google Sheets Apps Script language.
All I was hoping to do is have the date in cell A2, which is selected by using data validation as a drop-down calendar (this is already set up), be reduced by 14 days when the image is clicked or increased by 14 days when the image is clicked. I realize this will require 1 script for each function.
For example:
1. The date is set via the drop-down calendar in A2 to 12/28/24
2. Clicking the changes (reduces) the date in cell A2 to 12/14/24
- OR-
3. Clicking the changes (increases) the date in cell A2 to 1/11/24
I'm all set with knowing how to assign the scripts to the images, it's just the script code for the date changes that I'm not getting right.
Thank you to anyone offering to assist!