IF Statement

eganji

How can I combine the following two formulas in one statement:

1)    IF([Patient Date of Birth]1 OR [Last Patient Visit Date]1) = BLANK OR NULL)

    THEN  ([Patient Date of Birth]1 AND [Last Patient Visit Date]1) = "1/1/1940"

2)    IF(NETDAYS([Patient Date of Birth]1, [Last Patient Visit Date]1) / 360 > 12, DATE(YEAR([Last Patient Visit Date]1) + 7, MONTH([Last Patient Visit Date]1), DAY([Last Patient Visit Date]1)), DATE(YEAR([Patient Date of Birth]1) + 19, MONTH([Patient Date of Birth]1), DAY([Patient Date of Birth]1))).

what I am trying to do is if that if first statement is true and happens, then replace the values in the second statement with "1/1/1940" and continue to the calculation is statement 2.

Thank you

 

Andreas S.

Hi Eganji,

I think what you are trying to archive is not possible. You can´t change the value of a different cell with a formular, you can only calculate the value of a cell from other cells.

But what I guess you need will be possible. 

My understanding of your description is

1. You have a column [PatientDateofBirth] which can have a real value or be empty

2. You have a column [LastPatientVisitDate] which can have a real date or be empty

Now I start to guess:

1. Do you want to plan a next visit in maybe a third column [NextVisit]?

2. If you know the birthday - you want to see the patient first time when he/she is 19 years old?

3. If you have seen the patient once - want to see again after 7 years?

Furthermore I am totally unsure what to do with the 12 years.

Maybe you can explain what you want to archive without the use of formulars first. Then we can maybe give you formulars which will do what you need.

Kind regards

Andreas