Macro Request

G

Gareth Saunders

Hi there

I'm wanting to be able to calculate the amount of working days between two
specific dates. For example, if we entered 1st January 2006 and today (17th
February 2006) it should give me a number of 41 (including today). Would
anybody be able to provide me with a macro for this?

Many thanks in advance

Gareth Saunders
BOFH
 
T

tina

you don't need a macro. just use the DateDiff() function. it's described in
Access Help, read up on it there for details on how it works.

hth
 
Top