Using ProjDateDiff Calendar

Home Forums Discussion Forum Using ProjDateDiff Calendar

Viewing 3 reply threads
  • Author
    Posts
    • #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

    • #413726
      Ismet Kocaman
      Guest

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

    • #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

    • #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

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