NETWORKDAYS(start_date,end_date,holidays) 1

[amal1973]

Hello ...
I am trying to use this function that is in Excell in Access 2000???
NETWORKDAYS(start_date,end_date,holidays).......

What I need to do is calculate the working days between two days ,start day and end day ..
do I have to use VBA for it and if so , could you help me to define what I need in the code
thankxxxxxxxxxxxx

 

[jtmach]

Check out thread 181-26850
The hardest questions always have the easiest answers.

 

[tlbroadbent]

Also, check faq181-261.

jtmach,

FYI: If you type thread181-26850 without spaces the Tek-Tips software will create a hyperlink. Same thing happens with FAQs as you can see above. Terry L. Broadbent
faq183-874 contains some tips and ideas for posting questions in these forums. Please review it and comment if you have time.
NOTE: Reference to the FAQ is part of my signature and is not directed at any individual.

 

[amal1973]

thank you ...
cant i use the Datedff function ,and where shell i write the code? shell i have a form from two text bpoxes to enter the startdate and finish date ? and where i should have the result .
thank you

 

[MichaelRed]

refer to the faq181-261 it includes the necessary info.

It DOES expect DAO data base/recordset, as it was written fro ver '97. If you are using ver 2K, you need to Prepend "DAO." to the "DateBase" and "RecordSet" declarations near the top. I also just (TODAY!!) learned (from GreelGirlau) that Outlook.txt IS a list of National Holiday Dates for various countries, and could be used to get a list of "Official" holiday dates (not to be confused with a list of OBSERCED holiday dates).

MichaelRed
mred@att.net

There is never time to do it right but there is always time to do it over

 

[amal1973]

Michael...
Geting the number of days between the dates
NumDays: DeltaDays([StDt], [EndDt])
It did not work .... ar shell i use dateDiff..also if you could tell me f the code in the link should work in access 2000
thank you