How to calculate number of business days if you don't have an end date (calculate instead based on today)?

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered

I have a Date Suspended field and I want to calculate the number of business days from "today" since the Date Suspended. 

This duration formula is returning nothing: WeekdaySub([Date Suspended],Today())

Photo of Dawn

Dawn

  • 40 Points

Posted 3 years ago

  • 0
  • 1
Photo of Xavier Fan

Xavier Fan, Champion

  • 410 Points 250 badge 2x thumb
Note that for the WeekdaySub function - the [Finish] date is listed first, then the [Start Date] is second:

i.e.WeekdaySub([Finish], [Start])
so the formula should be (for a Formula - Numeric field) WeekdaySub(Today(), [Date Suspended])

which returns a Number with the number of business days since [Date Suspended] to today.
To turn this from a Number to a Duration - use the Days function:
(for a Formula - Duration field) Days( WeekdaySub(Today(), [Date Suspended]) )
Photo of Dawn

Dawn

  • 40 Points
Brilliant as always! :smile: Thanks much!
Photo of Xavier Fan

Xavier Fan, Champion

  • 410 Points 250 badge 2x thumb
You're welcome - happy to help!