somfin4u2c
New Member
- Joined
- Mar 17, 2015
- Messages
- 11
I need a formula to add days to a column of dates unless blank then add days to the previous column.
I have 3 columns (A) Date Out, (B) Date Last Serviced, and (C) Service Due
I need to add 14 days to (B) Date Last Serviced to get (C) Service Due This formula works fine for this =IF(ISNUMBER(B4), DATE(YEAR(B4),MONTH(B4),DAY(B4)+14),""
but if (B) Date Last Serviced is blank I need it to add 14 days to (A) Date out.
Any help would be greatly appriciated
I have 3 columns (A) Date Out, (B) Date Last Serviced, and (C) Service Due
I need to add 14 days to (B) Date Last Serviced to get (C) Service Due This formula works fine for this =IF(ISNUMBER(B4), DATE(YEAR(B4),MONTH(B4),DAY(B4)+14),""
but if (B) Date Last Serviced is blank I need it to add 14 days to (A) Date out.
Any help would be greatly appriciated