1 Reply Latest reply on May 21, 2014 6:35 AM by philmcgeehan

    how to calculate the number of mondays between two dates

    jbrogers1234

      Title

      how to calculate the number of mondays between two dates

      Post

           ok so how would you calculate the number of mondays  or Tuesdays or any day between two dates?

        • 1. Re: how to calculate the number of mondays between two dates
          philmcgeehan
               Put this in a calculation field:
                
               Int ( ( DayOfWeek ( DateStart - 3 ) - DateStart + DateFinsh ) / 7 )
               /*
                Change the number above to the respective day you want to count:
                   1  -  Sundays
                   2  -  Mondays
                   3  -  Tuesdays
                   4  -  Wednesdays
                   5  -  Thursdays
                   6  -  Fridays
                   7  -  Saturdays
               */
                
               Or you could have another field where you'd select a weekday and a Case statement in place of the number.