Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
SET statement tutorial | Excel Discussion (Misc queries) | |||
If statement | Excel Discussion (Misc queries) | |||
Do I need a sumif or sum of a vlookup formula? | Excel Worksheet Functions | |||
7+ nested if statement? | Excel Worksheet Functions | |||
Statement | Excel Worksheet Functions |