6 Month Anniversary Formula

ksmith870
ksmith870 ✭✭
in Formulas and Functions

Hello Everyone,

I am an excel wiz but I realize formula writing is totally different within smartsheet. I need help projecting 6 months in advance date. I used the following formula. =DATE(([Start Date]6) + 1),(([Start Date]6) - 6),([Start Date]6)). Any help would be great!

image.png


Tags:
· Share on FacebookShare on Twitter

Answers

  • Itai
    Itai ✭✭✭✭✭✭

    Hey @ksmith870,

    If you dont need it to be very accurate you can use =[Start Date]@row + 182

    Itai Perez

    Reporting and Project Manager

    If you found my comment helpful any reaction, Insightful, Awsome etc... would be appreciated🙂

    https://www.linkedin.com/in/itai-perez/

    · Share on FacebookShare 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!