Welcome!

formula

Hello I'm trying to create a formula and having problems trying to locate in Help. I just need the formula to add 3 years from a date the original class was taken. So if the class was taken 7/17/2015, I need to formula to automatically enter 7/17/2018. thanks!

Find more posts tagged with

Comments

Mike Wilday

=[Date Column]24 + 1095

will give you the date + 1095 days which is 356 days * 3.

This formula assumes it is row 24 and requires the column to be a date type.

Sign in to join the conversation!

Quick Links

Trending discussions

How can I view the Gantt chart in days?
When I use the zoom-in option, I can only see the day names but not the specific day numbers. I need my team to be able to see the exact dates for the tasks I have scheduled.
How to create stack column graph bars
I'm trying to create a graph chart that captures monthly count of records by divisions (Northeast, West and Central) that should be stacked with a legend displaying each by different color like a presented in Excel. When I attempt to duplicate the process in Smartsheet I receive the following results. In Excel, I created…
Not enough space in the cell for my notes
Hi, I'm using smartsheet to track updates on each task in a tracker. These updates may span over a year, so they get lengthy. I was excited about smartsheets because viewing these notes is a lot cleaner. However, I've just realized that there is a content limit to a cell, which is a huge issue. While excel was annoying to…