David
Thanks for your comments
I though I had a parenthesis error because of th wording in the message.
I initially copy and pasted the formula...when I got the error.....returning
to the forum to view your response and the previous one.......I entered the
formula with comma separators......and got a result......I' tried copy and
pasting again and and that works too......so I am uncertain why I got the
error.....in my efforts to introduce an error to find out what I'd done
wrong.... I cannot recreate the original eror message.
More importantly.....my question has been answered...and I am grateful for
all contributions.
Cheers


"David Biddulph" wrote:

It's never desperately helpful to say "it returns an error message". Youre
more likely to get help if you tell the group WHAT error message you're
getting.

Why do you suggest a problem with parenthseses? They look to me as if they
match, and Excel doesn't report an error for me.

The most likely problem of which I could think is that perhaps your regional
settings expect a semi-colon as a list separator, whereas the formula as
quoted includes commas. Have you checked your regional settings? Have you
tried changing commas to semi-colons (or whatever your settings are
expecting)?
--
David Biddulph

"Dermot" wrote in message
...
Thanks for the reply Gary
I think there is something wrong with the parenthesis with this formula as
it returns an error message.
Any further suggestions?

"Gary''s Student" wrote:

put the start date in A1, the number of weeks in B1 and the offset in C1
In D1 put:
=DATE(YEAR(A1),MONTH(A1),DAY(A1)+7*B1+C1)
and format as dd/mm/yy
--
Gary''s Student - gsnu200723