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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

WORD VBA Search and switch to advanced ... 1
number of months and days between two dates without approximation 3
Macro Search Button 1
a DateAdd question? 4
Multiple IF's ?? 2
Macro that can sort out a variabel name among others in a row and 0
Macro Needed 1
A better explanation of help required 3

Top