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
Related:
- Setting due dates
- Whatsapp time setting - Guide
- Safe search setting - Guide
- Lg tv setting subtitles - Guide
- Lg tv setting aspect ratio - 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))
