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
