Thread: Date Problem

Hi
I have got 3 coloumns in a worksheet : start date,end tate and number of units
I have to create a formula in such a way that if start date is for example
25oct and end date is 4rth nov, no of units should be distributed on the
prorata basis,as in some in the month of oct and the rest in nov
i started by creating 12 different cols for months like jan,feb,mar so
on.....but i dont know how to create this formula....
Pls help as this prob is really crucial for my job


thanks