Date Formula

Options

Hello,

I have a "Renovation Start Date" and a "Estimated Renovation Completion Date" column.

If the "Renovation Start Date" is blank and does not have a date, I want to the "Estimated Renovation Completion Date" column to also remain blank.

However, if the "Renovation Start Date" is does have a date I want the "Estimated Renovation Completion Date" to be 30 calendar days from the "Renovation Start Date".

I am having difficult time with this formula

This is what I have so far:

=IF([Renovation Start Date]1 = "", "", 30)


Any help would be greatly appreciated.

Thanks,

JC

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!