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

• 0
• Question
• Updated 3 years ago

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())

• 40 Points

Posted 3 years ago

• 0

Xavier Fan, Champion

• 410 Points
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]) )
• 40 Points
Brilliant as always! :smile: Thanks much!

Xavier Fan, Champion

• 410 Points
You're welcome - happy to help!