dateadd with workday?

[nodding dino]

I would like to be able to take a start date and use the dateadd function to get that date plus a number of days. The problem I have is that I would like to add WORKDAYS to the original date and not the usual days...

anyone have any ideas?

THANKS!

 

[Fergus]

What's the dateadd function?

 

[nodding dino]

Returns a Variant (Date) containing a date to which a specified time interval has been added.

Syntax

DateAdd(interval, number, date)

Quoted from VBA help.

 

[Fergus]

OK, sorry, didn't realise you were talking about vba, not my scene sorry.

 

[nodding dino]

no problem Fergus...thanks anyway!

 

[nodding dino]

still stuck...does anyone know how I can get around this problem?

THANKS!!!