Share via

MS Project Dates

Anonymous
2017-05-26T18:41:41+00:00

Is it possible to change the date , say June 23, 2017, to a month number, say month 1, then have all the other months following correspond. i.e. Month 2, Month 3,...

Microsoft 365 and Office | Access | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. John Project 49,705 Reputation points Volunteer Moderator
    2017-05-26T20:05:37+00:00

    Brennen,

    Are you talking about Project fields (e.g. Start, Finish, etc.) or the timescale for the Gantt Chart?

    If you want to use month numbering for the Start and Finish fields you will be forced to use manual scheduling mode. And then you will also have to manually enter durations so you will lose virtually all the automated scheduling Project offers.

    If you don't want to live with the limitations of manual scheduling mode, you could create a custom text field for the start of each task. The following formula should give what you want. Unfortunately the formula becomes considerably more complex if tasks cross a year boundary. In that case, I'd use a VBA approach to populate the custom field.

    Text1="Month " & (month([Start])-month([Project Start])+1)

    If you are referring to the timescale of the Gantt display then you can select various monthly labels that start from the Project start (e.g. month1, Month2, or m1, M2, etc.

    Hope this helps.

    John

    Was this answer helpful?

    3 people found this answer helpful.
    0 comments