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?

On Nov 23, 1:57*pm, Barbara Sabatino wrote:
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?


Try this formula:
=IF(D8="",IF(C8<DATEVALUE("10/22/2010"),E8+15,C8+15),IF(D8<DATEVALUE("10/22/2010"),E8+15,D8+15))

On Nov 23, 2:39*pm, goshute wrote:
On Nov 23, 1:57*pm, Barbara Sabatino wrote:





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?

Try this formula:
=IF(D8="",IF(C8<DATEVALUE("10/22/2010"),E8+15,C8+15),IF(D8<DATEVALUE("10/22*/2010"),E8+15,D8+15))- Hide quoted text -

- Show quoted text -

Yea--it worked! Thank you so much!