Worksheet is an action log. It has a column containing "due dates".
I want to count all rows (dates) that are "less than" today (to see what work is overdue).
I also want to count all rows (dates) that will come due in a week.
Conditional formatting highlights them OK but I also want to maintain a set of counts.
I can do all this in a macro but I don't want to use macros, just formulae.
Any ideas?
Thanks in advance.
Last edited by tonywig; 03-27-2009 at 05:22 AM.
Tony
Hi,
=countif(a1:a10,"<"&today())I want to count all rows (dates) that are "less than" today (to see what work is overdue).
=countif(a1:a10,"="&today()+7)I also want to count all rows (dates) that will come due in a week.
Adapt ranges to your needs
Many thanks
I was close to that but never quite got there.
Works a treat.
Thanks, was searching for this too.
Cheers for the post
nick
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks