Hi

Try
application.WorksheetFunction.WorkDay(range("A1"), 90)

--
Regards

Roger Govier


"A.G.M ash" wrote in message
...
Actually just realised my error the answer is simple. but now i have
come
across another prob.


how do i say

if 90 days after 18th october = saturday or sunday then do nothing
till monday



"A.G.M ash" wrote:

Hi
Funny question for you all, been tryin to think of an answer but had
no look.

how do you tell excel to Do x every quarter

but the quarter start and date to do is user defined

i.e.
Do x if date now() = 18th and month = three months after october

date and month will be looked up in different cells but i can sort
that out
I just cant think of a way of telling excel to count 3 months from x
month

many many many thanx in advance