Quick Links

MS Project Calendar IF Condition (Advanced)

Home Forums Discussion MS Project Calendar IF Condition (Advanced)

  • This topic is empty.
Viewing 3 posts - 1 through 3 (of 3 total)
  • Author
  • #481598 Reply

    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 Reply
    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 Reply

    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 3 posts - 1 through 3 (of 3 total)
Reply To: MS Project Calendar IF Condition (Advanced)
Your information:

− 1 = 5