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.

2 replies

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