Hi,
Would be grateful if anyone could give some much needed advice. I am currently trying to calculate earned premium by any given month based on a table of data using only a start date and an end date and total premium. I have around 60k lines of data and need to summarise how much premium is earned by month. Earned premium being calculated by premium / 365 * days on cover.
Basically the formula should calculate the number of days on cover within any given month and then calculate the premium as per above - the calculation of those days on a grand scale is proving problematic.
thanks
Bookmarks