Applies to
- Pro
- Business
- Enterprise
Capabilities
Who can use this capability
- Owner
- Admin
- Editor
Use formulas to perform calculations with dates
You can place a formula in one cell (formatted with a Date column type) that adds or subtracts numbers from dates in other cells.
Who can use this?
Plans:
- Smartsheet
- Pro
- Business
- Enterprise
Permissions:
- Owner
- Admin
- Editor
Find out if this capability is included in Smartsheet Regions or Smartsheet Gov.
Users on an Enterprise plan can use AI to generate formulas. Learn more.
The following table contains examples of using dates in formulas. The dates in the table below are in mm/dd/yy format. Numbers are treated as days, unless date functions are used.
| Date | Formula | Description | Result | |
|---|---|---|---|---|
| 1 | 5/19/17 | =Date1 - 5 | Subtracts 5 days from the date | 5/14/17 |
| 2 | 12/10/17 | =Date2 + 5 | Adds 5 days to the date | 12/15/17 |
| 3 | 1/20/18 | =DATE(YEAR(date12), MONTH(date12) + 1, DAY(date12)) | Add a month to the date with use of the DATE, YEAR, MONTH, and DAY functions | 2/20/18 |
- You can't place formulas in date columns being used for dependencies. See Enabling Dependencies & Using Predecessors for more on dependencies.
- The month and day value used in the DATE Function are restricted. Learn more about the date function.
Still need help?
Use the Formula Handbook template to find more support resources, and view 100+ formulas, including a glossary of every function that you can practice working with in real time, and examples of commonly used and advanced formulas.
Find examples of how other Smartsheet customers use this function or ask about your specific use case in the Smartsheet online Community.