How to return a different value if the reference cell is blank

[PeterVE95]

Hello,

Looking for help to solve this issue.

My command is still returning "Overdue" when the Due Date column is blank. How can I only return Overdue if the Due Date is > Today?

Thank you

[PeterVE95]

Thank you that worked!

[Kaviraj11 · Accepted solution]

Hi,

You can try this

OverdueStatus =
IF(
ISBLANK('YourTable'[Due Date]),
BLANK(),
IF(
'YourTable'[Due Date] < TODAY(),
"Overdue",
BLANK()
)
)