every quarter
Roger,
Workdayis not a Worksheetfunction, it is ATP.
I don't think he want to add 90 workdays anyway, I think he needs
Debug.Print Format(Application.Run("ATPVBAEN.XLA!WORKDAY", Range("A1").Value
+ 89, 1), "dd/mm/yy")
--
HTH
Bob Phillips
(replace somewhere in email address with gmail if mailing direct)
"Roger Govier" wrote in message
...
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
|