how to create Business Days(continues number)?

[system]

Karthishan,

I don’t know if this will help you or not. I needed to do something similar and created this variable:

=If(IsNull([Submitted Date]);(Floor(DaysBetween([Date Approved];[Production Date])+1)-(Truncate(((DayNumberOfWeek([Submitted Date])+(DaysBetween([Submitted Date];[Production Date])))/7);0)*2));(Floor(DaysBetween([Submitted Date];[Production Date])+1)-(Truncate(((DayNumberOfWeek([Submitted Date])+(DaysBetween([Submitted Date];[Production Date])))/7);0)*2)))

It’s a combination of three other variables I found somewhere on these boards (can’t seem to find the original anymore) but it basically counts the number of weekends in the date range and subtracts those days back out of the total. One of my developers has since taken this formula and rewritten it into a dimension of the universe to hide the complexity of the formula.

Obviously [Submitted Date], [Date Approved], and [Production Date] are the Dimensions from the query.

This post may also help you out.

120×120 10.4 KB

Hi - Im trying to get the difference between two dates but I want to know the number of BUSINESS days and not just the absolute number of days. I have used the following formula so far: =DaysBetween( ,) is there any trick I can use to get BO to tell me the number of Work days elapsed? Thanks Mandy Maximo625 (BOB member since 2006-04-26)

Or try searching for NETWORKDAYS (the Excel function that accomplishes this) or Business Days on the forum and you’ll find some other ideas.

---

jtleach (BOB member since 2006-05-19)