Excel Formula

Copper Contributor

I want a formula that lets me add 10 (days) to a date only IF a date is entered into a particular column.  

2 Replies
If the Column on which you want to determine the presence of a date is Column A, the date to which you may add 10 days is in B1, and the formula cell is C1, enter this:
=(SUMPRODUCT(—ISNUMBER(A:A))>0)*
10+B1

@lritterskamp 

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.