PRORATE Function

Returns a portion of a value divided across a provided date range.
Sample Usage
PRORATE(100, [Due Date]1, [Due Date]4, [Due Date]3, [Due Date]4)
Syntax
PRORATE(
  • number
  • start_date
  • end_date
  • prorate_start
  • prorate_end
  • [
    decimal_places
    ]
)
  • number
    The number to prorate.
  • start_date
    The first date in the value range.
  • end_date
    The last date in the value range.
  • prorate_start
    The first date in the range to prorate.
  • prorate_end
    The last date in the range to prorate.
  • decimal_places
    —[optional]
    The default is 2. The number of decimal places to round the result.
Was this article helpful?
YesNo