Results 1 to 3 of 3

Thread: week/year (wwyy) format

  1. #1
    Neophyte amorito's Avatar
    Join Date
    Jan 2020
    Posts
    1
    Articles
    0
    Excel Version
    2016

    week/year (wwyy) format



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi everyone,

    I am looking for create a gantt chart to track different stages of projects, I tried rearranging a template I found that had the week already in the template (the only one i could find). Each stage has a start and end date, and the date has to be entered in the wwyy format. The screenshot below shows what I have as of now. I need assistance having the dates being represented on the chart to the right, and also be able to scroll through the chart instead of having one that goes all the way to 53 wks(looking to make it a little more concise, so all the information can be seen at a glance). The year shown above can be updated, but I am looking for a way to have it change as I scroll through the chart.

    Thank you for your help.



  2. #2
    Neophyte Saquo's Avatar
    Join Date
    Apr 2020
    Posts
    2
    Articles
    0
    Excel Version
    2017
    Hi! I am currently in public transport and I am reading this on a phone. Let me get to my property in Ayia Napa and I will answer you through a PM message.

  3. #3
    Administrator AliGW's Avatar
    Join Date
    Nov 2015
    Location
    Ipswich, Suffolk, England
    Posts
    1,400
    Articles
    0
    Excel Version
    Office 365 Subscription
    Quote Originally Posted by Saquo View Post
    Hi! I am currently in public transport and I am reading this on a phone. Let me get to my property in Ayia Napa and I will answer you through a PM message.
    No, you won't. This is a public forum and all solutions offered must be made here so everyone can benefit from them.

    For future reference, save your responses until you are able to provide a solution.
    Ali
    Enthusiastic self-taught user of MS Excel!

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •