LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
SLP SLP is offline
external usenet poster
 
Posts: 58
Default duplicate row based on calculated number of months

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Sum cells based on number of months rck Excel Worksheet Functions 6 July 24th 09 04:00 PM
calculate number of months based on one date JK Excel Discussion (Misc queries) 1 March 5th 09 05:51 PM
I want to create a calculated item based on a calculated field Stijn Excel Discussion (Misc queries) 1 August 25th 08 05:30 PM
Excel for calculating stock cover based on a number of months sale DubaiGeorge Excel Worksheet Functions 2 November 1st 07 05:21 PM
Code for auto filling in Excel based on number of months, & start date Diane Sulton Excel Programming 1 March 1st 06 01:15 AM


All times are GMT +1. The time now is 10:41 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"