How do I...?

can any one help me Calculate working week-days?

I am trying to calculate the number of working week-days from two dates, at the moment it is giving me the full 7 days per week.

1 vote
Vote
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    I agree to the terms of service
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    Sam DoréSam Doré shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

    1 comment

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      I agree to the terms of service
      Signed in as (Sign out)
      Submitting...
      • John McGarveyJohn McGarvey commented  ·   ·  Flag as inappropriate

        Hi Sam,

        There is a date function just for this.
        Hope this is what you are looking for.
        John
        ---

        weekdays()
        This function returns the number of weekdays spanned by date1 and date2, including both date1 and date2.

        weekdays({Date Field 1}, {Date Field 2})

        Note: If using this function alone, you would insert the function into a calculated text or calculated number field type. Because it returns a whole number, it will not be accepted into a date field type.

      Feedback and Knowledge Base