Here's a puzzling one for you guys to help me out with.

[JJRudd]

Practice Dec Tracker.xls
	G	H	I	J
3	First Date Eligible	Last Date Received	Last Date Denied	Next Date Eligible
4	22-Feb-97	27-Mar-05		27-Mar-08
5	8-Jul-99	23-Jun-02		23-Jun-05
6	23-Oct-01			23-Oct-01
7	23-Mar-03			23-Mar-03
8	24-Apr-04			24-Apr-04
9	24-Nov-04			24-Nov-04
10	7-Jan-05			7-Jan-05
11	13-Jan-05	27-Sep-04		27-Sep-07
EPR Tracker

J1=IF(H4="",G4,(DATEVALUE(MONTH(H4)&"/"&DAY(H4)&"/"&YEAR(H4)+3)))

Here's a fun one. You can see the formula in J1 that I'm using to show a date 3 years beyond what's in H1 if H1 is filled. If it's not, then it shows G1. Now, I'm wanting to modify the formula to show a date in J1 that is 1 year beyond a date entered in I1 whether or not a date is entered in H1.

Basically I need J1 to show:
G1 if H1 and I1 are empty.
H1 plus 3 yrs if H1 filled.
I1 plus 1 yr, no matter if H1 filled or not.

Also, Is there a way I can shorten the code that it's showing in the Screen Shot? To do the same thing, add 3 yrs to a date in F1?

 

[barry houdini]

Is the date in I4 simply input by the user or the result of another formula?

If the former then you probably need VBA to do that, not my strength but it shouldn't be particularly difficult

 

[JJRudd]

It's a manually put in date. It's not that big of a deal to delete it myself, it's just a nice thing if it can be automatic.