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

If A1 contains: 25/10/05
B1: 04/11/05

Then in A2 type =DATE(YEAR(A1),MONTH(A1)+1,0)-A1+1 (answer 7)

and in B2: B1-DATE(YEAR(A1),MONTH(A1)+1,0)+1 (answer 5)

You can then use 7 and 5 to pro-rata your variable. (7/12ths and
5/12ths)

Hope this helps
Mike


--
Mikeopolo
------------------------------------------------------------------------
Mikeopolo's Profile: http://www.excelforum.com/member.php...o&userid=18570
View this thread: http://www.excelforum.com/showthread...hreadid=546941