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.