Help with Dates

[Don]

I have a form with several unbound text boxes.

txtSTART_DATE
txtEND_DATE
txtTOTAL_WORK_DAYS
txtCURRENT_WORK_DAY

I've used the following code to find the values of the first two text boxes,
but I can't come up with anything to give me the last two.

Me.txtSTART_DATE = DatePart("m", DLookup("[INV_THRU]", "tblDATA")) & "/1/" &
DatePart("yyyy", DLookup("[inv_thru]", "tbldata"))
Me.txtEND_DATE = DateAdd("m", 1, Me.txtSTART_DATE) - 1

I only want to return the total work days (Mon-Fri) for the month. Then I
want to return the current number of work days worked so far, in the month.

Am I asking for something that can't be done? Any help would be appreciated.

 

[Mr B]

Don,

Not to be short with you, but I would suggest that you do a search in this
newsgroup for "workdays". There are a couple of really good answers that
should get you going.

If that doen't do you some good, then come back and post here and perhaps
someone will be able to assist you.