B
Barbara Sabatino
I have a formula that I set up that should be working, but is not
functioning properly. My spreadsheet has 4 fields:
Initial Date, Follow-up Date, Rec'd Date, Due Date.
The first 3 dates are populated from a database. The fourth, Due
Date, is a calculation with a formula. The formula is to determine
from the 3 dates which one should be used to calculate the Due Date,
and then add 15 days to that determined date. In some cases the
initial date is a recent date, and the formula works fine. In other
cases it is an old date and formula does not work correctly.
Sometimes there is a follow up date, sometime not, and sometimes the
follow up date is recent and sometimes it is old. My formula uses a
date checker of 10/22 for the Initial and Follow Up dates b/c anything
prior to that date is considered legacy and should not be used to
calculate the Due Date.
E.g.,
Initial = 6/1/2010
Follow-up = is blank
Rec'd = 11/22/2010
In this case I want to calculate the Due Date off of the Rec'd Date by
adding 15 Days and receiving a Due Date of Dec. 10. However, my
formula below, keeps reverting to using the Initial Date. For the
formula below, Initial = C, FU=D and Rec'd=E.
IF(D8="",IF(C8<10/22/2010,E8+15,C8+15),IF(D8<10/22/2010,E8+15,D8+15))
Any advice on what might be wrong with this?
functioning properly. My spreadsheet has 4 fields:
Initial Date, Follow-up Date, Rec'd Date, Due Date.
The first 3 dates are populated from a database. The fourth, Due
Date, is a calculation with a formula. The formula is to determine
from the 3 dates which one should be used to calculate the Due Date,
and then add 15 days to that determined date. In some cases the
initial date is a recent date, and the formula works fine. In other
cases it is an old date and formula does not work correctly.
Sometimes there is a follow up date, sometime not, and sometimes the
follow up date is recent and sometimes it is old. My formula uses a
date checker of 10/22 for the Initial and Follow Up dates b/c anything
prior to that date is considered legacy and should not be used to
calculate the Due Date.
E.g.,
Initial = 6/1/2010
Follow-up = is blank
Rec'd = 11/22/2010
In this case I want to calculate the Due Date off of the Rec'd Date by
adding 15 Days and receiving a Due Date of Dec. 10. However, my
formula below, keeps reverting to using the Initial Date. For the
formula below, Initial = C, FU=D and Rec'd=E.
IF(D8="",IF(C8<10/22/2010,E8+15,C8+15),IF(D8<10/22/2010,E8+15,D8+15))
Any advice on what might be wrong with this?