I have a spreadsheet of issues with start and close dates and would like to get an average of how long issues stay open for.
Column A: Start Date
Column B: Close Date:
Column C: How long the issues was open using =B2-A2
I tried using the average formual but get an error divo. Is it possible to get an average of numbers that came from a another formula?
By: Julie Leeks