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.
Joy