Date Formula

McAfee Electric Mgr

McAfee Electric Mgr ✭✭✭✭

02/09/22 in Formulas and Functions

Does anyone have a formula to calculate the date 90 days from current date?

Example:

Current Date Next Due

02/09/2022 (formula to display) 05/09/2022

Thanks!

0 ·

Best Answer

Sunny Zebe ✭✭

02/09/22 Answer ✓

Have you checked this article?
https://help.smartsheet.com/articles/2477601-use-formulas-perform-calculations-dates

0 · Share on Facebook Share on Twitter

Answers

Sunny Zebe ✭✭

02/09/22 Answer ✓

Have you checked this article?
https://help.smartsheet.com/articles/2477601-use-formulas-perform-calculations-dates

0 · Share on Facebook Share on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions

If Statement Help
I could really use some help! I am trying to write an if statement. Based on: Due date being < = -68 New entry is "starred" Entry 1 = "yes". I want it to be complete if it meets the conditions listed above and incomplete if it doesn't meet those conditions. This is what I tried: =IF([New Entry]@row = 1, [Entry 1]@row,…
can i use sumif formula with my criteria referencing a cell in my sheet?
Hi Im trying to create a formula that pulls a sum from different sheet when the criteria matches a cell in my current sheet- is this possible? i get invalid operation when i try…
Countifs, with a cross reference and an or
Hi there, I'm trying to count how many red risks I have in my RAAIDD log that are not closed or complete. I've written the below, but I can't get it to work. Any advice would be gratefully received, please. =COUNTIFS({NAME RAAIDD Range 1}, "Risk", {NAME RAAIDD Range 3}, ">=8", {NAME RAAIDD Status}, OR(@cell = "Open", @cell…