View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Joanne
 
Posts: n/a
Default 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