Inferior statement

Question

Hello, I have the formula below with date fields. How can I please include an error message in my formula if AP2 is blank?

=IF(P2-AP2<365,"Death<1 year",Death >=one year")

I have tried adding iferror and'"Date missing")

Answer 1

Try this:

=IF(ISBLANK(A1),"Date Missing",IF((B1-A1)<365,"Death<1 year","Death >= one year"))