Edate based on 3 date variables

[davids4500]

Hi everybody..
I have an excel spreadsheet as attached.
three columns have dates A1 which is todays date, H3 is the second date and J3 is the third date.
I need a formula that applies these 3 criteria:- If J3 = 0, and H3 = zero then P3 =EDATE(A1, O3), but if J3 = 0 and H3 has a date then P3 = EDATE(H3, O3), but if J3 has a date (and H3 may also have a date) then P3 =EDATE(J3, O3)

 

[Alex Blakenburg]

You're welcome. Glad we could help.
PS: The fact that Round fixed it, indicates that the 8 in column O is not exactly 8 where it is even something like 7.99999 it will cause edate to only advance by 7 months.