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
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.
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:
- Setting due dates
- Whatsapp time setting - Guide
- Lg tv setting subtitles - Guide
- Safe search setting - Guide
- Redial setting in android - Guide
- Idm language setting - Guide
2 responses
jirinetmelissa
Posts
4
Registration date
Wednesday January 7, 2015
Status
Member
Last seen
January 8, 2015
Jan 7, 2015 at 04:14 PM
Jan 7, 2015 at 04:14 PM
if cell has date add 14 days, if cell has text then leave blank
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!"
=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!"
jirinetmelissa
Posts
4
Registration date
Wednesday January 7, 2015
Status
Member
Last seen
January 8, 2015
Jan 8, 2015 at 04:11 PM
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
So..
if cell b2 has date add 14 days (results in c2), if cell b2 has text or blank then leave c2 blank
jirinetmelissa
Posts
4
Registration date
Wednesday January 7, 2015
Status
Member
Last seen
January 8, 2015
Jan 8, 2015 at 04:12 PM
Jan 8, 2015 at 04:12 PM
=IF(if(istext(D:D),"",D:D+14)),(if(ISBLANK(D:D),"",D:D+14))
