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

1. ## 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?

2. Hi

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

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•