MS Project Calendar IF Condition (Advanced)

Home Forums Microsoft Project Discussion Forum MS Project Calendar IF Condition (Advanced)

  • This topic is empty.
Viewing 2 reply threads
  • Author
    • #481598

      I want to know how could I enter the if statement mentioned to the standard calendar in project. “If a holiday falls on a Saturday then Friday will be given as an extra day off, and if it falls on a Sunday, then Monday will be given as a day off.”

      Does anybody can provide a auto solution to it.

    • #481610
      Daryl Deffler

      Not the solution you’re looking for, but create a Project calendar based on the standard calendar. Manually scan it for any conditions, such as a holiday on a weekend, and manually mark the appropriate Friday/Monday as a non-working day. Not sure of the need for the “If” logic, but once you’ve marked the day(s) as non-working, all Project functions such as scheduling will work appropriately.

    • #481614

      To the best of my knowledge, formulas only work on custom fields, they cannot be used to change default fields. Your best option is to follow Daryl’s advice.

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