+ Reply to Thread
Results 1 to 9 of 9

Calculate pro rata based on start/end date

Hybrid View

Olli Saccount Calculate pro rata based on... 03-10-2019, 07:30 AM
AliGW Re: Calculate pro rata based... 03-10-2019, 08:00 AM
Olli Saccount Re: Calculate pro rata based... 03-10-2019, 02:50 PM
shg Re: Calculate pro rata based... 03-10-2019, 04:11 PM
Olli Saccount Re: Calculate pro rata based... 03-11-2019, 02:42 PM
shg Re: Calculate pro rata based... 03-11-2019, 03:41 PM
Olli Saccount Re: Calculate pro rata based... 12-04-2021, 03:18 PM
bsalv Re: Calculate pro rata based... 12-04-2021, 03:51 PM
Olli Saccount Re: Calculate pro rata based... 12-04-2021, 04:46 PM
  1. #1
    Forum Expert
    Join Date
    01-25-2011
    Location
    Belgium, Alveringem
    MS-Off Ver
    Excel 2003, 2007, 365
    Posts
    1,419

    Re: Calculate pro rata based on start/end date

    question : is it 91+90=181 or 92+89=181 for both years ?
    =MAX(0,MIN(DATE(Table2[[#Headers],[2018]],1,1),$C3)-MAX(DATE(Table2[[#Headers],[2017]],1,1),$B3))
    Attached Files Attached Files
    Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.

  2. #2
    Registered User
    Join Date
    03-10-2019
    Location
    Berlin
    MS-Off Ver
    Office 365
    Posts
    5

    Re: Calculate pro rata based on start/end date

    Thank you very much for your input. That is exactly what I needed. Concerning your question: It would be rather 91+90.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 3
    Last Post: 06-23-2015, 09:56 AM
  2. Calculate next due date based on start date frequency and current date
    By ironoverload in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-09-2014, 07:08 AM
  3. [SOLVED] Calculate END DATE based on START DATE & No of working days
    By prashantha in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 11-20-2013, 07:22 AM
  4. Replies: 0
    Last Post: 03-21-2013, 12:22 PM
  5. [SOLVED] Calculate date based on number of weeks or months after start date
    By wotsup in forum Excel General
    Replies: 3
    Last Post: 08-17-2012, 06:00 AM
  6. Calculate START date based on duration (work hours) and END date
    By kaaver in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 07-06-2010, 12:21 PM
  7. Calculate start date based on working hours and end date
    By kaaver in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-28-2010, 06:58 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1