DATE Formula help
Answers
-
great formula but I am looking for a slight tweek.
I have two columns. Date Requested and Date Expires
I need the Date Expires column to reflect the date in the Date Requested column PLUS two years
So:
Date Requested Date Expires
12/20/2023 12/31/2023
I used this formua: =DATE(YEAR([Date Requested]@row) + 2, MONTH([Date Requested]@row), DAY([Date Reqeusted]@row)) and it gets the year right, but I can't figure out the Day part
-
@damon.tackett Do you mean you want the last day of the month two years after the [Date Requested]?
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
@Paul Newcome Correct. So if in my Date Requested column the date is 12/20/2023 in my Date Expires column it updates it to 12/31/2025.
I see that I forgot to update the year on my previous example. Sorry about that.
-
Try this:
=IFERROR(DATE(YEAR([Date Requested]@row) + 2, MONTH([Date Requested]@row) + 1, 1), DATE(YEAR([Date Requested]@row) + 3, 1, 1))
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 379 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 304 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!