I have a list of applications and their due dates (some applications are due
on the 5th day and some are due on the 28th day). Here is a partial example:

Case # 5th Day 28th Day
111111111 15-Jan
222222222 2-Feb
333333333 1-Feb

There are up to 500 rows of applications in my list. I need to get a total
of both columns that are due before today and calculate the result in a
single cell in another worksheet. I also need to get a total of both columns
that are due two weeks from today, also calculating the result in a single
cell in the other worksheet.

Can you help me please? I can't seem to think of the correct formula.
Thanks.

Before today:
=COUNTIF(B:C,"<"&TODAY())

Within the next two weeks:
=COUNTIF(B:C,"<"&TODAY()+14)-COUNTIF(B:C,"<=&TODAY())
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Bradly" wrote:

I have a list of applications and their due dates (some applications are due
on the 5th day and some are due on the 28th day). Here is a partial example:

Case # 5th Day 28th Day
111111111 15-Jan
222222222 2-Feb
333333333 1-Feb

There are up to 500 rows of applications in my list. I need to get a total
of both columns that are due before today and calculate the result in a
single cell in another worksheet. I also need to get a total of both columns
that are due two weeks from today, also calculating the result in a single
cell in the other worksheet.

Can you help me please? I can't seem to think of the correct formula.
Thanks.