|re: i can't code|
There is no coding required to set up columns for example data. Simply click on the pre tags found at the top of the Reply box and enter your data in between those tags:
A B C
1 date name task
2 5-20 xxx OT
3 5-25 xx OT
One solution is to enter this formula in D2 and drag it down:
Whenever the date in Column A is 2 or more days (48 hours) less than Today's date, a 1 will be placed in Column D. If it is less than 2 days, Column D will remain blank.
Then all you have to do is SUM Column D.
You could also use a letter or word and the COUNTIF function:
In D2, use this formula:
If you want, you could put those formulas in a hidden column and just display the total. There are lots of options.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.
message edited by DerbyDad03