Formula to mark record as overdue or current

I have a spreadsheet with column c giving date and time (dd/mm hh:mm) and I'd like column D to contain a formula that will:

Mark as "OVERDUE" if it is 24hours or more past the data in column c, or
"current" if it's less than 24hours past the data in column c.

I hope I've explained that clearly :/

So far I've only figured out how to do it if it's "1 day" past the date, but that totally ignores the times in that cell, of course.

Any help? I am rather stuck.

Thanks in advance

Originally Posted by sooshi

I have a spreadsheet with column c giving date and time (dd/mm hh:mm) and I'd like column D to contain a formula that will:

Mark as "OVERDUE" if it is 24hours or more past the data in column c, or
"current" if it's less than 24hours past the data in column c.

I hope I've explained that clearly :/

So far I've only figured out how to do it if it's "1 day" past the date, but that totally ignores the times in that cell, of course.

Any help? I am rather stuck.

Thanks in advance

Does this work?

Please Login or Register  to view this content.

Ah!!!! That's it! Thanks very much!

I was using If =IF((TODAY()-C1>=1,"OVERDUE","current")

Doh! All the difference

Thanks guys!