6 Month Anniversary Formula

ksmith870

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!

Itai Perez

Hey @ksmith870,

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