+ Reply to Thread
Results 1 to 1 of 1

convert dates to calendar schedule showing how much to bill them each calendar month

  1. #1
    Registered User
    Join Date
    01-23-2005
    Posts
    20

    convert dates to calendar



    Ok, here is what I need. I have a sheet (as attached), that outlines a schedule of payments from a customer. The dates are setup something like this:
    Start ---------Finish ---Price Per Month
    12/1/2008 - 12/13/2009_ $100
    12/14/2009 - 4/15/2010_ $126
    4/16/2010 - 5/1/2010_ $0.00
    5/2/2010 - 5/1/2014_ $500

    All of these numbers must have the ability to be modified.

    What I need is to calculate how much to bill them each calendar month. Such as:

    Novemer 2008--December 2008 ... December 2009--January 2009
    ---$100------------$100---------$41.94+73.16------$126.00

    Note that, as long as it is a full month, they are charged the full month (ie a month with 28 days is not less expensive than one with 31). However, if the month is split between two payment schedules, it's days determine how much to charge from either plan. Also, the months in the calendar should not be calendar, but manually entered.

    I greatly, greatly appreciate your help!!!
    Attached Files Attached Files
    Last edited by TheOne; 03-27-2008 at 05:01 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1