Define different date results in one cell

[ltdcmdjaw]

UPDATED.
Cell A2 (if used) will have a date to be calculated with a 14 day result in E2, unless
B2 (if used) will have a date to be caculated with a 12 month result in E2, unless
and C2 (if used) will have a date to calculated with a 7 year result in E2, unless
finally D2 (if used) will have a result entered as "permanent".
The (if used) means that only one of cells (A2, B2, C2, D2) will be used. with the results in E2.
How would this formula be written?

[shg]

And while you're at it, could you also provide a better explanation of what you're trying to do, and several examples?

[ltdcmdjaw]

sorry about the confusion. have update/edit my post at top, a little new with this. thanks for your patience

[jeffreybrown]

Here is one way in E2 copied down...

Please Login or Register  to view this content.

[Cutter]

If I understand the priority correctly then:

=IF(N(D2),"Permanent",IF(N(C2),EDATE(C2,84),IF(N(B2),EDATE(B2,12),IF(N(A2),A2+14,""))))

[ltdcmdjaw]

Thanku, thanku, thanku... this worked perfectly!!

If I understand the priority correctly then:

=IF(N(D2),"Permanent",IF(N(C2),EDATE(C2,84),IF(N(B2),EDATE(B2,12),IF(N(A2),A2+14,""))))

[ltdcmdjaw]

thanks jeff

Here is one way in E2 copied down...

Please Login or Register  to view this content.

[jeffreybrown]

You are very welcome. Glad we could help and thanks for the feedback

[Cutter]

Yes, you're welcome.