Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi, I have an Excel workbook based on an Access query. It shows billing
dates and paid dates with amounts by client along with other stuff. Some bills get paid the same months and some can take up to 12 months to get paid. I need to display, per month, all bills that have not yet been paid, no matter when they were submitted. Anyone have any ideas on how I can do this? For example, if a bill was submitted in January and not paid until June, it would show up in Jan, Feb, March, Apr, May, and June. Looking forward to help as the boss just told me he needs this today. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Sum cells based on number of months | Excel Worksheet Functions | |||
calculate number of months based on one date | Excel Discussion (Misc queries) | |||
I want to create a calculated item based on a calculated field | Excel Discussion (Misc queries) | |||
Excel for calculating stock cover based on a number of months sale | Excel Worksheet Functions | |||
Code for auto filling in Excel based on number of months, & start date | Excel Programming |