Date Differences - multiple dates, with blank values

[smmedeiros]

Looing for help. Not good with nested statements.
i have 3 date values
active
decom
today()

need formula to calculate date difference
if active populate and decom blank, date value is today()-active
if active populated and decom populated, date value is decom-active
if active = blank and decom populated, value needs to display as "NA"

active, decom are independate date values on same row, different columns

Thanks in advance for any guidance available

 

[Deniall]

Breaking it up a bit with linefeeds for clarity:
IF(ISBLANK(active),
IF(ISBLANK(decom), "awaiting data", NA()),
IF(ISBLANK(decom), TODAY()-active, decom-active)
)

 

[smmedeiros]

Thank You Deniall! Appreciate the help.