HI,
I am new member in this forum. I have been trying to find a formula calculating monthly cost for an activity from the quarterly cost figures considering start finish date of the activity. but no luck. I will be grateful if someone can help!
here is the requirement;
Activity start finish dates varies can be from beginning of the quarter to end of the quarter or from middle of the quarter to middle of next quarter. Need to distribute quarterly values evenly to the months.
For example in below table, activity A, excel formula should help distribute Q1=60 to months Jan, Feb, and March evenly.(each month should be 20); while Activity B, q1 value-20 should be divided equally between Feb and March (nothing for Jan since start date is Feb), and q2 value-40 should be distributed to April and May equally.
here is the attachment...
Start Finish Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec q1 q2 q3 q4
Cost of activity A 1/01/2013 31/03/2013 60 0 0 0
Cost of activity b 1/02/2013 31/05/2013 20 40 0 0
Bookmarks