formulating dates excluding weekends

07/26/18 Edited 12/09/19

I have 3 columns with different dates. My goal is to enter 1 date, and have the other 2 dates formulated based off the 1st date. I created a formula to satisfy this need, but I am ending up with some dates falling on weekends, which I cannot have. Is there a way to correct this issue without enabling dependencies and predecessors?


  • Paul NewcomePaul Newcome ✭✭✭✭✭

    What is your current formula? You may want to try (if you aren't already) a NETWORKDAY or a NETWORKDAYS function.

  • Maz UddinMaz Uddin ✭✭✭✭✭

    @Paul Newcome

    Hi Paul

    i want to generate a list of dates excluding

    do you know how i can do this please?

Sign In or Register to comment.