Results 1 to 3 of 3

Revenue allocation between two dates

Threaded View

  1. 11-30-2019, 12:43 PM #1
    mikedharding
    mikedharding is offline
    Registered User
    Join Date
    11-30-2019
    Location
    Tonbridge, England
    MS-Off Ver
    Office 365
    Posts
    1

    Revenue allocation between two dates

    I am trying to allocate revenue on a contract between two dates but am struggling. I'm going back and forth using IF, AND, EOMONTH but just can't get the right formula. Help please! See attached
    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. [SOLVED] Allocation of products based on order entry and delivery dates
    By isalmon in forum Excel General
    Replies: 6
    Last Post: 12-03-2018, 08:12 PM
  2. [SOLVED] How to use dates as reference in allocation of a certain amount based on different %
    By MyStix01 in forum Excel General
    Replies: 10
    Last Post: 09-21-2017, 08:03 PM
  3. Calculating Prorated Revenue Off of Dates with Monthly Straddles
    By KevDeCar in forum Excel General
    Replies: 1
    Last Post: 01-08-2015, 08:02 AM
  4. Milestone dates to calculate a revenue payment
    By bdlchicago in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-23-2014, 11:24 AM
  5. Calculating the revenue by month between two different dates
    By AkilaAnnamalai in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-09-2014, 04:00 AM
  6. Revenue allocation using combined/Nested IF statements
    By Irfan123 in forum Excel General
    Replies: 9
    Last Post: 07-28-2008, 09:29 AM
  7. [SOLVED] Calculating revenue per month by aggregating dates
    By Commutervet in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 02-17-2006, 10:20 AM

Tags for this Thread

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