Formula to show overdue event and count total of "overdues"
Posted by Anthony McGlynn on February 12, 2002 3:09 PM
I am trying to write a formula where by comparing a date to the currenr date I can see when it becomes overdue (after 90 days) and for a summary sheet I require to count the total of the overdues for the entire sheet.
Any help would be most appreciated
Anthony
Posted by IML on February 12, 2002 3:31 PM
You can highlight overdue with conditional value
choose value less than and put
=NOW()-90
in the box.
You can count overdue occurance, assuming they are in column A, with
=COUNTIF(A:A,"<"&NOW()-90)
good luck
![](https://pinterest.com/pin/create/bookmarklet/?url=https%3A%2F%2Fwww.mrexcel.com%2Farchive%2Fformulas%2Fformula-to-show-overdue-event-and-count-total-of-overdues%2F&description=Formula to show overdue event and count total of "overdues"&media=https%3A%2F%2Fwww.mrexcel.com%2Fimg%2Fmrexcel-publishing.png){kind=link}