Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

number of days within business days

Status
Not open for further replies.
LinPro

LinPro

Programmer
Jun 25, 2003
120
US
Hi All

I am trying to do a Sales report. I seen how number of business days are calculated between 2 dates. However, what I need is how to get the number of days within the business days.

Example.

If I am in Nov - there is 19 business days for my company. I am executing my report on Nov 11th. Which means I am on the 8th day of the 19 days. I need to figure out how to calculate for the 8th day.

thanks.
Lin
 
Status
Not open for further replies.

Similar threads

B
  • Locked
  • Question
Difference of a field between 2 variable dates
Replies
1
Views
242
hilfy
hilfy
Corinne30
  • Locked
  • Question
Division of currency formula with/without rounding
Replies
7
Views
765
dgillz
dgillz
Brian S
  • Locked
  • Question
Splitting names that have variable numbers of spaces 1
Replies
5
Views
407
Brian S
Brian S
PJ222
  • Locked
  • Question
is date within any date range in a dynamic array of date ranges
Replies
1
Views
193
PJ222
PJ222
socalvelo
  • Locked
  • Question
Limiting the number of records in groups and sub-reports 1
Replies
2
Views
195
socalvelo
socalvelo

Part and Inventory Search

Sponsor

Back
Top