6 Month Anniversary Formula


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!



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!