How to generate dates

[#1]

Hi,

I have created the following calendar in my script in order to look at each cover day for each policy. I now need to calculate the date for each policy date by adding one to each date up to 365 i.e. if a policy starts on 2/12/2014 I want this to be marked as coverday 1, 3/12/2014 to be coverday 2 etc. I am struggling to get this to work. Does anyone have any ideas?

[prieper]

From which date you wish to calculate?

Why not using a straightforward formula:

MyDate - StartDate + 1 = coverday

(plus probably adding some formula to detect the expiry of the policy)

HTH Peter

[#3]

Thanks Peter, this is something similar to the solution I have found.