Populate same Cell with 2 possible out comes with If(isblank)

Hi,
I am trying to populate a cell (R3) with 2 possible out comes, although I can't work out how to do it. Both formulas are below and are required in cell (R3). Basically if (T3) is populated with a date (R3) returns a completed statement, but I also require (R3) to return a blank cell if (S3) is not populated with a date.

=IF(ISBLANK($T3),$S3+365,"Completed")
=IF(ISBLANK($S3),"",$S3+365)

Any help would be appreciated.

Kevin.

So only if there are dates in both S&T you want R to return "complete", and in other scenarios R will remain blank?

try this:
=IF(AND(ISNUMBER(T3),(ISNUMBER(S3))),"completed","")

Hi AliGW,
Thanks for looking at this, but I require the Eye sight due box (R3) to either display complete if there as been a test taken in (T3) or to display nothing if the last eye sight test (S3) as not been yet been populated. At the moment I can do one or the other but not both in the same cell. I have tried to simplify it by keeping it on one sheet but there are sheets for say next year and of course the eye sight test hasn't been done yet!

Hope that explains it better!
Once again thank you,
Kevin.

If both S3 and T3 are blank then R3 is displaying 30/12/1900 with the formula =IF(ISBLANK($T3),$S3+365,"Complete")
If both S3 and T3 are populated R3 is displaying Complete with the same formula

The last eye sight test (S3) will require checking first.

If none of the criteria are met then then it's just the same if S3 and T3 are blank R3 auto populates the formula with a figure of 30/12/1900 which I want to be blank.

Thanks.

Thanks for replying Belinda, but I still require the formula of S3+365 to be displayed in the Eye Sight Test R3 cell. Everything else did work. So thanks. I just that formula in there somehow.

Kevin.

Wow!
Thanks for this it works a treat. I will have to work out how the formula works now! I don't just like to copy.

Much appreciated!!

Kevin.

I suppose you are adding 365 to add a year. Is it important that leap years be taken into account ? Or should the date be a weekday ? ( I guess not, just to be sure)

Hi,
So I assume the ,12 after EDATE refers to 12 months? I have just looked up the EDATE function and I didn't know about that. Looks good so I will put that into my spreadsheet. Thanks for all your help! I was banging my head against a brick wall before this.

Kevin.