0
0

Using ProjDateDiff Calendar

Home › Forums › Microsoft Project Discussion Forum › Using ProjDateDiff Calendar

Tagged: 

Viewing 3 reply threads
  • Author
    Posts
    • 10/14/2018 at 1:08 pm #413725
      Anonymous
      Inactive

      Hello,

      I am using Microsoft Project 2016.
      In a custom field I have a formula that utilizes the ProjDateDiff(start,finish,calender) function.
      How do I specify the calendar so that ProjDateDiff uses the calendar for the resource assigned to the task?

      Thank you,

      Craig

    • 10/14/2018 at 1:31 pm #413726
      Ismet Kocaman
      Guest

      ProjDateDiff( [Start], [Finish], “Resource name” ) will do it.

    • 10/14/2018 at 8:37 pm #413727
      Anonymous
      Inactive

      Hello,

      Thank you for the response.
      If I am applying this field to all tasks and I have several resources, how do I specify that ProjDateDiff uses the resource assigned to each task automatically. If I apply one resource name it woln’t it apply to all tasks?

      Craig

    • 10/16/2018 at 11:36 am #413740
      Ismet Kocaman
      Guest

      You can use the Resource Names field for this purpose as in ProjDateDiff(…, …, [Resource Names]) provided that all tasks are single-resourced tasks with 100%. Otherwise it will probably return #ERROR.

      Ref. https://support.office.com/en-us/article/resource-names-task-field-9000102b-2622-4f40-8619-6061ff964376

  • Author
    Posts
Viewing 3 reply threads
  • You must be logged in to reply to this topic.