Age in NetworkDays

[CesarAustin]

Hello
Hope someone can help me.. What I’m trying to do is figure an age. In my table I have a column of dates (named Ord_Date).. In the column next to that I would like to calculate an age. Which I have… Date: NOW()-[Ord_Date]…. Which works.. But, I need to calculate Network Days/Business days… I know how to do it in excel.. But having a hard time in access.. pls help..

 

[tails]

I'm not really good at this but i'll give it a shot.
If you try entering that code that you have, it should automatically convert it into days right? is it possible to have a field (this will b a long process) that will divide it by 7, so that you can see how many weeks are in that. then with the days take 2 days off for every 7 days, or even just mulitply that date by 5 instead of 7 or something like that. I think it could work. just a thought, add onto it if u must but its a thought.

 

[bmacr]

There must be something for you at this link:

http://www.mvps.org/access/datetime/index.html