creating columns based on date range
 

Hello:

I have an inventory spreadsheet that contains the following columns: Item
ID, Quantity, and Due Date.

I would like to create a pivot table or something along those lines that
shows the following four columns: Item ID, Items Past Due, Items Due This
Week, and Items Due in the Future. Those last three date columns are based
on the Due Date column in my spreadsheet.

Is there a way to have Excel create such a table of columns based on a range
of due dates? The table, of course, would have to compare the computer
system's date (i.e. today's date) with the Due Date in order to create
accurate columns.

childofthe1980s