Results 1 to 12 of 12

Need help - calculating daily, weekly, and monthly totals based two dates and networkdays

Threaded View

tgosman Need help - calculating... 08-07-2015, 10:16 AM
pjwhitfield Re: Need help - calculating... 08-07-2015, 10:44 AM
tgosman Re: Need help - calculating... 08-07-2015, 03:24 PM
tgosman Re: Need help - calculating... 08-11-2015, 09:14 AM
tgosman Re: Need help - calculating... 08-11-2015, 09:14 AM
pjwhitfield Re: Need help - calculating... 08-11-2015, 09:25 AM
pjwhitfield Re: Need help - calculating... 08-11-2015, 10:01 AM
tgosman Re: Need help - calculating... 08-11-2015, 10:43 AM
pjwhitfield Re: Need help - calculating... 08-11-2015, 11:46 AM
tgosman Re: Need help - calculating... 08-11-2015, 01:00 PM
tgosman Re: Need help - calculating... 08-12-2015, 07:55 AM
pjwhitfield Re: Need help - calculating... 08-12-2015, 01:38 PM
  1. 08-07-2015, 10:16 AM #1
    tgosman is offline
    Registered User
    Join Date
    07-31-2013
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    11

    Need help - calculating daily, weekly, and monthly totals based two dates and networkdays

    Only bill for week days during billing cycle (i.e. M-F).
    More than 3 days = 1 week's rental
    More than 3 weeks = 1 Month's Rental

    Currently "Days" in column E are calculated using Networkdays function.
    Based on entering two dates (Rent start, Rent finished), I need to calculate the number of Months, Weeks, and Days then run a formula to calculate the total value to invoice.

    The highlighted cells under columns J,K,L on row 18 are my initial attempts at this calculation. Please Help!!

    I've attached the excel sheet.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. summing daily weekly & monthly totals
    By jrtaylor in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 04-10-2014, 04:49 PM
  2. Calculate Daily, Weekly & Monthly Averages of daily Data not using Pivot Table
    By PWinkz in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-01-2013, 05:05 AM
  3. [SOLVED] How do I group daily totals into weekly/monthly/quarterly totals
    By situationroom in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-28-2013, 09:58 AM
  4. Semi-monthly Timesheet with OT calculating based on daily and weekly limits
    By trs43 in forum Excel General
    Replies: 0
    Last Post: 12-03-2012, 05:17 PM
  5. Calculate Totals weekly and Monthly from daily Figures
    By mfjanoo in forum Excel General
    Replies: 3
    Last Post: 03-05-2012, 03:06 PM
  6. suming daily information into weekly 5 or 7 day weeks, monthly, 3 monthly, 6 monthly
    By belkin in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-11-2008, 05:57 AM
  7. Collecting weekly and monthly totals from daily data
    By Kasper in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 01-12-2006, 04:10 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1