Generate Weekend Dates When Project Settings are Monday - Friday

@Kerlyn Mottershead I moved your question to a separate thread.

Your question:

I have a problem and hope you have a solution.

My project duration days are weekdays only so I set my project settings as such. However, I do have a few tasks that only occur on weekends and my sheet is not calculating that in based on my settings. Do you have a formula that will deliver a date based on a predecessor that is a weekend and ignores the weekday? I hope that made sense.



  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭

    @Kerlyn Mottershead Do you have dependencies enabled on your sheet?

    If so, you will need to either adjust the working days in your project settings, turn them off and replicate how they work using formulas, or use a second date type column that would house a formula, but this second column would not be usable in the dependency settings.

  • Thanks! I will try to replicate the settings using a formula.

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭

    Happy to help! 👍️

    Feel free to let me know if you would like some assistance on getting those put together.