:confused: Can anyone tell me how I can phase a value (Linear) between 2 dates?

:confused: Can anyone tell me how I can phase a value (Linear) between 2 dates?

I consider myself a moderately intelligent guy but I have no clue what you're asking for. Can you re-state the problem?

If by Phasing you mean that you want to generate records for every day between two different dates so as to populate a table with one record per date, I suggest that this is BEST done using VBA code. However, every time I see such a request, I immediately think that something else is wrong with the structure.

What is the underlying problem that would require you to populate a table with a series of dates between two limiting dates?

I consider myself a moderately intelligent guy but I have no clue what you're asking for. Can you re-state the problem?

I am trying to phase a budget across a specific period that I expect the budget to be spent. Say I have £100 and want to phase it between 01/03/09 & 31/12/09. The calc would need to determine the number of days (per month) between the 2 dates and then be used to divide the budget up accordingly and possibly stored by month too!

Hope this explains better.

Cheers
Iain.