How to use multiple criteria when 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 from today, 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 some of it & it half works...

=IF(DAYS360(J32, TODAY())<61, "Not Past Due", DAYS360(J32, TODAY()))

The reason it half works is that is diplays "Not Past Due" when even when a value is not due more than 60 days from today.

The issue I'm having is that when I try to introduce a second IF function to display the message "Due" if the due date is within 60 days of today, the formula doesn't work. I think the problem is something to do with the fact the numbers generated are negative (because they are not yet overdue).

Can anyone figure out how to do this?

Thank you in advance

 

[tori14]

Got it, the one of the cells being referenced also contains a time stamp!
Thanks for your help guys!!

 

[Cosmic Wizard]

They are all formatted to general. Could it be to do with the fact that the due date in cell J3 is being calculated by a formula?

Pretty sure that its: try the formula with just a normal date and see what happens.