Been scrambling my brain with the formula for this. Appreciate any help.
In Cell AF1, I have the formula for today's date =NOW()
I have several columns with dates in them. D:D K:K R:R Y:Y
In Cell AF2, I would like a formula that calculates how many cells in D:D,K:K, R:R and Y:Y are past due...