Counting cases between dates
=COUNTIF(A1:A20,""&TODAY()-6*7)
=COUNTIF(A1:A20,""&TODAY()-18*7)-COUNTIF(A1:A20,""&TODAY()-6*7)
=COUNTIF(A1:A20,"<="&TODAY()-18*7)
Adjust the range to suit.
--
David Biddulph
"Lisa" wrote in message
...
Hi, I am using a waiting list of our clients and i would like to be able
to
calculate how many are on the list, from todays date, that have been
waiting
less than 6 weeks, 6 - 18 weeks and 18 weeks+. I would be very grateful
for
any help with this as it's driving me mad :(
--
Many thanks, Lisa
|