EDATE Substitute

Hangout_pros

Hangout_pros ✭

10/01/22 edited 10/03/22 in Formulas and Functions

Hi there ,

can anyone help me figure out a formula on this ? Need to add the "Contract term" in months, to the "Effective date", to get the "End date",

0 ·

Answers

Paul Newcome ✭✭✭✭✭✭

10/03/22

Here is a link to a thread with a solution:

https://community.smartsheet.com/discussion/66572/what-is-formula-edate-from-excel-in-smartsheet

CERTIFIED SMARTSHEET PLATINUM PARTNER
10xViz.com
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

SUMIFS formula syntax
Hi, I believe I'm needing help with the syntax for the SUMIFS formula. See the below photo with example data: I am wanting to total the revenue generated for each department (category) and sub department (topic) only if the status is labeled "Won" - which the above screenshot would not be included in the total. The "Topic"…
Dynamic "Week Of"
Hello, Is there a way/formula I could write to get a single cell to display a dynamic "Week of XX/XX" regardless of what day today is? I want to display it for a report that will always be the previous Monday-Sunday and will roll forward the next Monday.
Return Multiple Values from a Lookup of Multiple Values
I have a training feedback form, and classes have multiple instructors. When the student picks multiple instructors, I need to look up the corresponding email for each instructor, usually only 2. you can see from my screen shot, I am getting an error if there is 2 to lookup, is this even possible or what is a recommended…