inserting date as plan start in Gantt project planner

Поделиться
HTML-код
  • Опубликовано: 21 авг 2024
  • A small manipulation for using date as 'plan start' in the Gannt project planner template of MS Excel 2013

Комментарии • 21

  • @Heart4KidsNonProfit
    @Heart4KidsNonProfit 3 года назад +4

    Please sir show in practical how to change the date on the column and also across at the top. Most clients. Most client wants to see real dates only. I think is crazy that Microsoft gave such a template without real dates to begin with.

  • @mickeyp1291
    @mickeyp1291 8 лет назад +6

    Dates are numbers. no reason to link to the cell, you can change the formatting to date and change the numbers to dates and it will work

    • @FinneyPhilipIndia
      @FinneyPhilipIndia 7 лет назад +1

      Thanks Mickey You are right,
      After Changing Periods, the Period Highlight is not Working Effectively, Can you please assist me

    • @alexvidu4517
      @alexvidu4517 5 лет назад

      Thanks for the Video clip! Apologies for chiming in, I would appreciate your thoughts. Have you thought about - Weydaniel Organized Dominator (Sure I saw it on Google)? It is a great one off guide for getting 7000 plus project management and business templates without the normal expense. Ive heard some pretty good things about it and my cooworker got great success with it.

    • @igormorozov6311
      @igormorozov6311 5 лет назад +1

      how to do it:
      www.microsoft.com/en-us/videoplayer/embed/RWfqjE?pid=ocpVideo0-innerdiv-oneplayer&postJsllMsg=true&maskLevel=20&market=en-us

  • @darshanmodi8862
    @darshanmodi8862 8 лет назад

    thanks for this
    it is also helpful....

    • @diegomendoza4957
      @diegomendoza4957 4 года назад

      Winner of a video, been searching for "which software is best for project management?" for a while now, and I think this has helped. Have you heard people talk about - Biycarlett Astounded Builder - (just google it ) ? It is a great one off guide for discovering how to download thousands of business and project management templates without the hard work. Ive heard some awesome things about it and my neighbour got excellent success with it.

  • @annielandgraf-cant190
    @annielandgraf-cant190 8 лет назад

    Hi! This is great, but is there a way of changing the actual periods to dates? So instead of period 1 (I8) I have 06/02 ? And can just put 06/02 as start and 08/02 as end date in columns C and D?

    • @jagdish240
      @jagdish240  8 лет назад

      +Anne Landgraf Hi! Its possible. Just change the number format of entire 8th row to the date format you wish and then also change the number format of cell N3 (Period Highlight) to the same date format. Hope thats what you are looking for.

    • @amandapanepucci974
      @amandapanepucci974 8 лет назад +1

      Good to point out you also then have to change the plan start and actual to dates as well (columns C & E). Thanks for this, it's helpful.
      Only new question is, once you change to dates, the period highlight no longer works. You can manually enter dates but the arrows take you back to 1990. Can you advise?

    • @poppicturehouse8013
      @poppicturehouse8013 7 лет назад

      How do I change the number format of cell N3 (period highlight) to the same date format? Was able to do the first bit but not the second..

    • @FinneyPhilipIndia
      @FinneyPhilipIndia 7 лет назад

      Hello Amanda, Have you got the solution for the Same, I am also stucked here

    • @chukwuanthony2447
      @chukwuanthony2447 7 лет назад

      Hi Amanda have gotten solution to it cause am facing the same issue here.

  • @ikramwasabi2692
    @ikramwasabi2692 6 лет назад

    what are you said to open the name manager

  • @nicolaiskjershede7122
    @nicolaiskjershede7122 3 года назад

    can you change the colors

  • @pandharinathjoshi6565
    @pandharinathjoshi6565 3 года назад

    Nice sir., pls share download link

  • @aparajitaghoshdastidar4645
    @aparajitaghoshdastidar4645 5 лет назад

    How do I get this template ???

  • @sarahs4922
    @sarahs4922 5 лет назад

    Wtf