Formula

[mrsmillicent]

what formula do i use to calculate scenario below? Thank you!

J2 can either be a date or blank
k2 already has a formula for vlookup to convert weeks to days
i need L2 to calculate if it's blank or if there's a date on J2, it adds the days in K2 and that's what shows up on L2.

 

[revcanon]

Place this formula in L2

=if(j2="","",J2+K2)

This formula says if J2 is blank, then L2 will be blank, if J2 is not blank then L2 = J2+K2

Is that what you were looking for?

 

[mrsmillicent]

You're awesome! thank you!