Future date based on text result and previu

Thanks - it doesn't work but I'm trying to tweak. It's certainly closer than I managed to get! It gave me 6 months for the "neg" even with the Edate(m1,12) for some reason. The 3 months is for another scenario which I probably shouldn't have included.

Basically, I need to track when to follow up a particular group of patients:

- Blood tests taken on date 'M1'
- Results in 'N1'
- If négative, no follow up for 1 year
- If <1.5E+1, follow up in 6 months is usually needed as it's a subset that had Hepatitis C but have been 'cured' theoretically (in some cases we can push to 12 months but for the sake of this, it will be 6 for all! (The 3 months is if they also have HIV...)
- if it's positive or reported with a numerical value of >1.5E+1 (the value shows the activity of the virus in their body), it has serious health implications if we don't take action again within a particular time frame as they are at high risk of developing liver cancer.

So, all the 'positives' and '>1.5...' also have Ultrasounds 1-2 x/year and other exams. However, it all starts with the blood test. I can't keep track of who needs what when without some form of dynamic dbase and my dept won't invest.

So thank you!

I think its adding 6 months (the last edate(M1,6) as default) as its not matching "neg" .
Maybe there is a trailing space like "neg ".
Maybe its "Neg"
Change the last edate to 24 months (or some other number of months not expected) to prove this theory.
Maybe post your data so we can see what you have. Remove names etc. before doing so.

Ah, yes! I had re-entered all the dates in column B before reading this - and it works! thanks!!! It even worked as expected when I re-opened it on the older PC system (I had also saved it in an older format just in case).
Cheers!!!