IF forumla on cell that sometimes blank, sometimes a date

[JohnnyPicnic]

Hi all,

I'm attempting to perform and IF statement against a cell that is sometimes blank and sometimes contains a date. The expected result is:
blank = leave blank
greater than 30 days = Data↑
between 15-30 days = Data↓

my formula =IF(TODAY()-D7>30, "Data↑", IF(AND(TODAY()-D7>=15, TODAY()-D7<=30), "Data↓",""))

I can't get to a formula that leaves the cell blank.

 

[Fluff]

How about

=IF(D7="","",IF(TODAY()-D7>30, "Data↑", IF(AND(TODAY()-D7>=15, TODAY()-D7<=30), "Data↓","")))

 

[JohnnyPicnic]

How about

=IF(D7="","",IF(TODAY()-D7>30, "Data↑", IF(AND(TODAY()-D7>=15, TODAY()-D7<=30), "Data↓","")))

Thank you! I had tried something similar but I think I missed space or comma somewhere.

 

[Fluff]

You're welcome & thanks for the feedback.