I am trying to calculate metrics from rows of data. At first, I tried to use macros and formulas (thanks XLD for suggesting array formulas). But now my manager wants the data combined for each project (which can have several lines). I've tried pivot tables, but I just can't seem to get anything to calculate in regards to the dates. I've attached a spreadsheet with example data. I'm not even sure this can be done since the data is not very consistent.
Thanks for any insight!
Kathyb0527