Loading...
Quick Links

Weekly Calendar on Visual Reports

Home Forums Discussion Weekly Calendar on Visual Reports

Viewing 2 posts - 1 through 2 (of 2 total)
  • Author
    Posts
  • #406947 Reply
    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 Reply

    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 2 posts - 1 through 2 (of 2 total)
Reply To: Weekly Calendar on Visual Reports
Your information: