TestMonth = (Range("A1").Value + 3) Mod 12
If TestMonth = 0 Then TestMMonth = 12

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"A.G.M ash" wrote in message
...
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