Results 1 to 6 of 6

[SOLVED]Invoiced days per month

Threaded View

  1. #1
    Registered User
    Join Date
    07-09-2007
    Location
    Houston
    MS-Off Ver
    2016
    Posts
    60

    [SOLVED]Invoiced days per month

    I am trying to help someone with a function and can not figure out what would be best to use. What I have is a start rent date and an end rent date. They want to break down how many days in each month the item was on rent so they have a column for each month. For example say an item was rented on 12/14/08 and returned on 1/12/09. It was rented for a total of 30days 18 days in December and 12 days in January. So I would need a function in each column that would return a 14 in the December Column and a 12 in the January Column. Any help would be greatly appreciated as there are over 350 rows and they are doing the process manually right now and taking several days. Thank you in advance.

    Also I just noticed that the date range is currently entered as a text in the format 2008-12-14 so YYYY-MM-DD. Don't know if the text will be a problem.

    Just attached an expample. In it I am trying to find a function to fill in the green cells.
    Attached Files Attached Files
    Last edited by txbullets; 03-03-2009 at 07:23 PM.

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