ISBLANK w/ Formula in target cell

Hi, looking to solve a problem I've been working on for a bit. I appreciate the help in advance!

In cell H3, I have the following: =IF(ISBLANK('Services Support'!C3),"",'Services Support'!C3)

That formula works fine for what I need should I put a date in Services Support cell C3.


In cell H4, I have the following: =IF(ISBLANK(H3),"",IF(H3<$A$1,"Expired",IF(H3-$A$1<=31,"Expires in "&H3-$A$1&" days","")))

In cell A1 I have =TODAY()


This is throwing a #VALUE! error in H4 because the cell in H3 is not truly blank due to the formula there. Does anyone know of a way to keep my formula in H3 and have H4 display appropriately?

Welcome to the forum.

=IF(H3="","",IF(H3<$A$1,"Expired",IF(H3-$A$1<=31,"Expires in "&H3-$A$1&" days","")))