Expire date notification multiple columns with blanks.

[Bob_ipc]

Hey All hope all is well, I'm hoping to get a little help with a notification when a date is near expire date. I have several columns of when employees training certificates expire, I would like excel to tell me in A:7 that the dates expire soon. some of the columns have blanks, I have this formula so far that works so long as there is a date in every column

=if(H7 < today()+90),"expires soon",""),if(j7 < today()+90),"expires="" soon",""),if(m7 < today()+90),"expires="" soon",""),if(o7 < today()+90),"expires="" soon",""),if(q7 < today()+90),"expires="" soon","")
<today()+90),"expires soon",""),if(j7<today()+90),"expires="" soon",""),if(m7<today()+90),"expires="" soon",""),if(o7<today()+90),"expires="" soon",""),if(q7<today()+90),"expires="" soon","")
How can I get this to work when any one of H7,J7,M7,O7 or Q7 may contain a blank?</today()+90),"expires>

 

[Peter_SSs]

Is this really the same question as this one?

 

[Bob_ipc]

Yes it would be the same question.

 

[Peter_SSs]

Then I am closing this one per #12 of the Forum Rules