Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Creating date range for x-axis label in Excel '07 | Excel Discussion (Misc queries) | |||
suggestions on creating a text value based on a date range | Setting up and Configuration of Excel | |||
Formula for determining if two date columns fall within specific date range | Excel Worksheet Functions | |||
Formula for determining if two date columns fall within specific date range | Excel Discussion (Misc queries) | |||
Creating Date Range in Pivot Microsoft Query | Excel Discussion (Misc queries) |