How do I show a specific date!

[Geneva Sachs]

This is the formula I've got now.

=IF(D2>TODAY(),D2,IF(D2+365*(C2)>TODAY(),D2+365*(C2),IF
(D2+730*(C2)>TODAY(),D2+730*(C2),IF(D2+1095*(C2)>TODAY
(),D2+1095*(C2),IF(D2+1460*(C2)>TODAY(),D2+1460*(C2),IF
(D2+1825*(C2)>TODAY(),D2+1825*(C2),IF(D2+2190*(C2)>TODAY
(),D2+2190*(C2),"Out of Range")))))))

The problem is, I NEED TO SHOW A DATE OF 5/1/(year) OR
11/1/(year).

This formula gives me a few days difference because of
leap years, etc.

HOW DO I GET THE FORMULA TO WORK?

Is this the formula I should be using for up to 6 years
out OR ELSE, indicate "Out of Range" OR is there a
different formula I could use?

THANKING YOU IN ADVANCE FOR ALL YOUR HELP!

GENEVA

 

[Mark Graesser]

The following formula will give you the exact date in D2 plus the number of years in C2

=DATE(YEAR(D2)+C2,MONTH(D2),DAY(D2)

If you could explain what it is you are trying to do I might be able to come up with a shorter formula

Good Luck
Mark Graesse
(e-mail address removed)


----- Geneva Sachs wrote: ----

This is the formula I've got now

=IF(D2>TODAY(),D2,IF(D2+365*(C2)>TODAY(),D2+365*(C2),I
(D2+730*(C2)>TODAY(),D2+730*(C2),IF(D2+1095*(C2)>TODA
(),D2+1095*(C2),IF(D2+1460*(C2)>TODAY(),D2+1460*(C2),I
(D2+1825*(C2)>TODAY(),D2+1825*(C2),IF(D2+2190*(C2)>TODA
(),D2+2190*(C2),"Out of Range"))))))

The problem is, I NEED TO SHOW A DATE OF 5/1/(year) OR
11/1/(year)

This formula gives me a few days difference because of
leap years, etc

HOW DO I GET THE FORMULA TO WORK

Is this the formula I should be using for up to 6 years
out OR ELSE, indicate "Out of Range" OR is there a
different formula I could use

THANKING YOU IN ADVANCE FOR ALL YOUR HELP

GENEV