Hi All,
i have a situation where i need to allocate funds or dollar amounts for each
calendar year (columns CY 2010 and CY 2011 and . Below is the table i have:

Start Date Finish Date Total Days Subtotal 2009
2010 2011
1-Mar-09 28-Feb-11 730 $149,398.78 ???
??? ???

What formula do i use for columns 2009, 2010 and 2011 to allocate the $$ for
each Calendar Year?
Thank you in advance.