VBA Date

[Ddempsii]

Looking for VBA help. I have a text box with a percentage that shows what the "pacing" percent to goal. In this text box I want to display a default value of the business day we are currently on divided by the total business days in the month. Hoping I can just write one code to automatically know the difference between months. If there are any questions please let me know!

[ItsMe]

Sounds complex to me. I would probably start by creating a temp table that only included records to represent each workday within a given date range. I would depend on the WeekDay() function to help me determine what a workday is.
https://msdn.microsoft.com/en-us/lib.../gg264334.aspx

[Ddempsii]

There's a good start, i'll start playing around with what you have posted. Thank you

[ItsMe]

I imagine there will be several small parts to the solution. If a new question arises that seems like it stands alone, that question may warrant its own thread. You might want to include a link to this thread in any new threads. Hard to say until you discover new questions.