If Then Statement Help
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
|