Adding 1 month as expiration date referring cell of registration
Answers
-
Can someone help me in my problem, I would like to do a formula about adding 1 month as expiration date but it's always INCORRECT ARGUMENT..
=DATE(YEAR([DATE OF REGISTRATION]@row, MONTH([DATE OF REGISTRATION]@row + 1, DAY([DATE OF REGISTRATION]@row))))
-
Hi,
Try having a look at this thread, Paul Newcome advised someone on similar matter, not sure how your sheet is set up, but you might need to have an additional column like in this example that contains the month and then add it perhaps?
Adding a number of months to a date using formulas — Smartsheet Community
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.8K Get Help
- 429 Global Discussions
- 146 Industry Talk
- 485 Announcements
- 5.2K Ideas & Feature Requests
- 86 Brandfolder
- 151 Just for fun
- 73 Community Job Board
- 497 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 306 Events
- 37 Webinars
- 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!