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
(thinking…)
Sign in with: facebook google
Signed in as (Sign out)
You have left! (?) (thinking…)
Sam Doré shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

1 comment

Sign in
(thinking…)
Sign in with: facebook google
Signed in as (Sign out)
Submitting...
  • John 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