I need help, I'm trying to put a formula in place for the following:

Date A: 1/1/2001
Date B: 12/31/2004
Date C: 1/1/2007

If Date B minus Date C (in numbers) is greater than Date C minus Date B than
I want it to take Date A and add the difference between Date B - Date A (in
#'s) and Date C - Date B (in #'s) to come up with a new date

If Date C minus Date B is greater than Date B minus Date A, I want to return
Date C

I hope this makes sense

=IF(DATE_BDATE_C,DATE_C-DATE_A,DATE_A)

I think, but I got a bit confused.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Joanne" wrote in message
...
I need help, I'm trying to put a formula in place for the following:

Date A: 1/1/2001
Date B: 12/31/2004
Date C: 1/1/2007

If Date B minus Date C (in numbers) is greater than Date C minus Date B
than
I want it to take Date A and add the difference between Date B - Date A
(in
#'s) and Date C - Date B (in #'s) to come up with a new date

If Date C minus Date B is greater than Date B minus Date A, I want to
return
Date C

I hope this makes sense

Hi Bob,

Maybe this is clearer:
Cell A1 1/1/04
A2 12/31/04
A3 1/1/07

If A2-A1 = 1460
A3-A2 = 731
Since A2-A1 is greater than A3-A2 I want to take the difference from
1460-731 (729) and add that to 1/1/04 to make a new date of 12/31/02 but if
the difference between A2-A1 and A3-A2 is negative, I want to return A3 as
the date.
Thanks

"Bob Phillips" wrote:

=IF(DATE_BDATE_C,DATE_C-DATE_A,DATE_A)

I think, but I got a bit confused.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Joanne" wrote in message
...
I need help, I'm trying to put a formula in place for the following:

Date A: 1/1/2001
Date B: 12/31/2004
Date C: 1/1/2007

If Date B minus Date C (in numbers) is greater than Date C minus Date B
than
I want it to take Date A and add the difference between Date B - Date A
(in
#'s) and Date C - Date B (in #'s) to come up with a new date

If Date C minus Date B is greater than Date B minus Date A, I want to
return
Date C

I hope this makes sense