Weekly Calendar on Visual Reports

Home Forums Discussion Forum Weekly Calendar on Visual Reports

Viewing 1 reply thread
  • Author
    Posts
    • #406947
      Emma Gibney
      Guest

      Hi,
      I’m trying to make a report similar to the resource usage view twhere the expected work of each person on each assignment is tracked by week. I’ve edited the Earned Value Over Time from the Visual Reports in order to get Weekly Calendar as one of the options so I could track based on time on my pivot table. The Weekly Calendar is broken down into year, quarter, and week number. Is there a way to make the week number (1-52) into actual dates?
      Thanks,
      Emma

    • #406948
      Daryl Deffler
      Participant

      Since the data has been exported to Excel, can you add a column and calculate a week date doing math with dates? Take the year starting week’s date and add 7 times the week number. For example, our starting week date for 2016 was 1/2/16. Therefore the formula on each week would be 1/2/2016 + (7 * (weeknumbercell – 1)). So our week 5 would be 1/2/16 +(7*(5-1)) or 1/2/16 +28 days or 1/30/16.

Viewing 1 reply thread
  • You must be logged in to reply to this topic.