Results 1 to 3 of 3

Calculating the Pro Rata Factor?

This is a discussion on Calculating the Pro Rata Factor? within the Excel Questions forums, part of the Question Forums category; What is the formula to calculate the Pro Rata Factor? Basically I want to be able to take 2 dates ...

  1. #1
    New Member
    Join Date
    Feb 2006
    Location
    California
    Posts
    1

    Default Calculating the Pro Rata Factor?

    What is the formula to calculate the Pro Rata Factor? Basically I want to be able to take 2 dates (start date - end date) then devide by 365 and come up with the pro rata factor. Can anyone help?

  2. #2
    acw
    acw is offline
    MrExcel MVP
    Join Date
    Feb 2004
    Posts
    4,814

    Default

    Hi

    If you are trying to calculate the percentage of a year the number of days between the 2 dates is then

    =(enddate - startdate)/365


    Tony

  3. #3
    MrExcel MVP
    Join Date
    Mar 2002
    Location
    Michigan USA
    Posts
    11,454

    Default Re: Calculating the Pro Rata Factor?

    What is the formula to calculate the Pro Rata Factor? Basically I want to be able to take 2 dates (start date - end date) then devide by 365 and come up with the pro rata factor. Can anyone help?
    Hi okemn:

    Welcome to MrExcel Board!

    I am not sure if this is what you are looking for ...

    ******** ******************** ************************************************************************>
    Microsoft Excel - Book1___Running: xl97 : OS = Windows XP
    (F)ile (E)dit (V)iew (I)nsert (O)ptions (T)ools (D)ata (W)indow (H)elp (A)bout
    =

    A
    B
    C
    D
    E
    1
    2
    StartDateEndDate
    3
    15-Feb-0621-Dec-041.153
    4
    Sheet1

    [HtmlMaker 2.42] To see the formula in the cells just click on the cells hyperlink or click the Name box
    PLEASE DO NOT QUOTE THIS TABLE IMAGE ON SAME PAGE! OTHEWISE, ERROR OF JavaScript OCCUR.


    formula in cell D3 is ... =(B3-C3)/365

    If I have misunderstood you rquestion, please explain a little more clearly and then let us take it from there.
    Regards!

    Yogi Anand, D.Eng, P.E.
    Energy Efficient Building Network LLC
    www.energyefficientbuild.com

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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


DMCA.com