How to use multiple criteria using IF 360DAYS & today() functions in one formula???

[tori14]

Hi all, first time poster - just wondering if anyone is able to help me correct the below formula please?
What I need is a formula that will:
a) calculate the number of days overdue a task is,
b) if a task is due within 60 days from today, display the message "Due",
and c) if a task is due in more than 60 days from today, display the message "Not Past Due".

I've got this, which is working kind of:
=IF(DAYS360(J3,TODAY())<-61,"Not Past Due",IF(DAYS360(J3,TODAY())>-61,"Due",DAYS360(J3,TODAY())))

The issue is it doesn't give a numerical value of days overdue in the cells that are overdue, it just automatically says "Due".

Can anyone figure out how to do this?

Thank you in advance

[hossat]

Hi


try this formula =IF(DAYS360(J3,TODAY())<61,"Not Past Due","Due")&" "&DAYS360(J3,TODAY())
Good luck