With the period start date in A1 and end date in B1 the following gives
the answers you want.

=((DAY(EOMONTH(A1,0)-A1+1))/DAY(EOMONTH(A1,0))+DAY(B1)/DAY(EOMONTH(B1,0)))*1000


--
Alex Delamain
------------------------------------------------------------------------
Alex Delamain's Profile: http://www.excelforum.com/member.php...o&userid=11273
View this thread: http://www.excelforum.com/showthread...hreadid=275586