I have a spreadsheet that I am tracking dates within. I put in just a date in a cell for a actual completion and a date with a P for pending (12/9/2009 P). I am trying to count yesterdays and today’s date with the P.
I am using is “=COUNTIF(Commission!I3:I796,"=12/8/2009 P")” and it works but I would like to use the “=TODAY()” and “=TODAY()-1”. That way I don’t have to change the formula daily.
I would also like to count the dates that fall into the current week and the next week.
I don’t want to separate the date if at all possible.
Thanks for any help.
Bookmarks