Skip to Content
0

Business days subtracting?

Feb 19 at 01:22 PM

13

avatar image
Former Member

I have 2 columns, one is Service_date and the other is Billed_date.

I need to calculate how many days between the two. A simple subtract will give me this difference. However, we need to account for vacation days.Both of these are datetime columns.

Is there a way to subtract but taking into account that we would ignore weekends ? Holidays would not be a problem as yet.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Ian Waterman Feb 19 at 02:28 PM
0
Share
10 |10000 characters needed characters left characters exceeded