Jul 28 2019 10:29 AM
I want a formula that lets me add 10 (days) to a date only IF a date is entered into a particular column.
Jul 28 2019 11:37 AM
Jul 28 2019 11:39 AM
This assumes that the date you are working with is a proper date-value and not a text string.
The formula
= IF( date, date+10, "" )
moves forward by 10 days whereas
= IF( date, WORKDAY(date,10), "" )
ignores weekends.