How to use multiple criteria using IF 360DAYS & today() functions in one formula???
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
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
Last edited: