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 |
All times are GMT +1. The time now is 05:15 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com