San Antonio Heat
Active Member
- Joined
- Oct 10, 2003
- Messages
- 333
- Office Version
- 2019
- Platform
- Windows
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 from AF1 date.
thanks
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 from AF1 date.
thanks
