If Statement ? Seperate cost over years of project

[Joy]

I have a series of data for projects with a project start date, a project end
date and a total amount for each project. I need to break the amount for
each project down into years by the no of days the project ran in each of the
years it ran (i.e. putting an amount under each year 2002, 2003, 2004). I am
assuming an if statement breaking the amount down to a cost per day would be
the way to go but am not sure how to go about getting data seperated for each
year.

 

[Luke M]

Formula structure:
=TotalCost * (Days worked in specific year / Total days worked)

If your year headers are going across in cells B1:F1, and number of days in
B2:F2, and total cost in A2, this maked your formula in cell B3:
=$A$2/(B2/SUM($B2:$F2))