Dear all
I have a huge worksheet , each entry has a received date in column C in the format of dd-mm-yy, and a date to be processed by in column F in the format of dd-mm-yy.
I have to count how many entries received each date, and also count by the date to be processed by.
How can I count and get it to list out by date?
P.S. the worksheet start from last Oct, each day there are many received entries with different date to be processed by.
Column C: Received Column F : To be processed by
Entry one 2 Oct 08 10 Oct, 08
Entry two 2 Oct 08 19 Oct, 08
.... etc
Also, I have a deadline to meet, all entries received should be done within 2 weeks.
And also to be done within the date to be processed by which may be less than 2 weeks.
I am bombarded by my boss saying I always delay,and write badly at my appraisal, I need to find proof and have to count these entries. I think percentage wise, there are not so much delays over the year. Is there a quicker way to do instead of using filter where I have to press many times.
Thanks a lot for helping me.
I have a huge worksheet , each entry has a received date in column C in the format of dd-mm-yy, and a date to be processed by in column F in the format of dd-mm-yy.
I have to count how many entries received each date, and also count by the date to be processed by.
How can I count and get it to list out by date?
P.S. the worksheet start from last Oct, each day there are many received entries with different date to be processed by.
Column C: Received Column F : To be processed by
Entry one 2 Oct 08 10 Oct, 08
Entry two 2 Oct 08 19 Oct, 08
.... etc
Also, I have a deadline to meet, all entries received should be done within 2 weeks.
And also to be done within the date to be processed by which may be less than 2 weeks.
I am bombarded by my boss saying I always delay,and write badly at my appraisal, I need to find proof and have to count these entries. I think percentage wise, there are not so much delays over the year. Is there a quicker way to do instead of using filter where I have to press many times.
Thanks a lot for helping me.