Thanks Gebob. Yeah you're right with the Formula just that I am unable to group that into my pivot to Prepare a Chart for that. I end up using that formula and copying all other details into separate sheet manually before I can table it all for Analysis and charting.

Is there a way to put that formula in Pivot table (Can Pivot do the calculation internally so it can have separate Project Yr Field in the Pivot Field list?)
This way its grouped together in the Pivot table and easier to work with.

Any help and all help will be appreciated.

Thanks Much!!!


By the way Gebob - I notice you said I should put the formula in e2 even though the Pivot is in A1 to E5. Is this even possible? Thanks