Previous Topic Next Topic

Setting due dates

Closed
jirinetmelissa Posts 4 Registration date Wednesday January 7, 2015 Status Member Last seen January 8, 2015 - Jan 7, 2015 at 04:01 PM
jirinetmelissa Posts 4 Registration date Wednesday January 7, 2015 Status Member Last seen January 8, 2015 - Jan 8, 2015 at 04:12 PM
I already have half of the formula needed..

d2=text, leave it blank =if(istext(D2),"","")

I need a formula for this:

d2=date, then add 14 days to the date


The whole formula goes in c2.
Related:

2 responses

Answer 1 / 2
jirinetmelissa Posts 4 Registration date Wednesday January 7, 2015 Status Member Last seen January 8, 2015
Jan 7, 2015 at 04:14 PM
if cell has date add 14 days, if cell has text then leave blank
0
Answer 2 / 2
Blocked Profile
Jan 7, 2015 at 04:45 PM
You had it with the first formula....just on the false parameter, add n 14 days as in:
=IF(ISTEXT(D2),"",D2+14)


In my example I put the formula in E2 instead of C2...oops. If your C column comes out with some whole number, then format the column as Date!

"If you would have told me 20 years ago that everyone was going to be a photographer in 20 years, I wouldn't have believed you!"
0
jirinetmelissa Posts 4 Registration date Wednesday January 7, 2015 Status Member Last seen January 8, 2015
Jan 8, 2015 at 04:11 PM
what if i want to do the same thing and add if blank.

So..

if cell b2 has date add 14 days (results in c2), if cell b2 has text or blank then leave c2 blank
0
jirinetmelissa Posts 4 Registration date Wednesday January 7, 2015 Status Member Last seen January 8, 2015
Jan 8, 2015 at 04:12 PM
=IF(if(istext(D:D),"",D:D+14)),(if(ISBLANK(D:D),"",D:D+14))
0