Loading...
Quick Links

Using ProjDateDiff Calendar

Home Forums Discussion Using ProjDateDiff Calendar

Viewing 4 posts - 1 through 4 (of 4 total)
  • Author
    Posts
  • #413725 Reply

    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 Reply
    Ismet Kocaman
    Guest

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

    #413727 Reply

    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 Reply
    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 4 posts - 1 through 4 (of 4 total)
Reply To: Using ProjDateDiff Calendar
Your information: