HotNumbers2001
Board Regular
- Joined
- Apr 21, 2002
- Messages
- 139
IF Formula:
I have to generate a date that is between 5 different Dates: for Example
I have a starting date of 10/23/02
Date 1 = 3/26/02
Date 2 = 3/26/03
Date 3 = 3/26/04
I need a formula that will give me the answer for date 2: 3/26/03
If Starting date should change to 10/23/03
I need the answer to be 3/26/04
To make more complex the Starting date could change to anything:
Also if Starting date should change to 1/23/02 I need the answer to be Date 1 3/26/02
Can someone please help me. I have been going crazy trying to write an IF statement.
I have to generate a date that is between 5 different Dates: for Example
I have a starting date of 10/23/02
Date 1 = 3/26/02
Date 2 = 3/26/03
Date 3 = 3/26/04
I need a formula that will give me the answer for date 2: 3/26/03
If Starting date should change to 10/23/03
I need the answer to be 3/26/04
To make more complex the Starting date could change to anything:
Also if Starting date should change to 1/23/02 I need the answer to be Date 1 3/26/02
Can someone please help me. I have been going crazy trying to write an IF statement.