Hi

Sorry, I didn't read carefully enough. It looks as you want the week with
1'st January in it off.
=DATE(YEAR(A1),1,9-WEEKDAY(DATE(YEAR(D1),1,1),2))


--
Arvi Laanemets
( My real mail address: arvi.laanemets<attarkon.ee )


"Ron@Buy" wrote in message
...
Stephen
Thanks for your response - BRILLIANT, works every time.
When I look at my efforts, I clearly have a lot to learn
Again many thanks,
Regards
Ron

"Stephen" wrote:

"Ron@Buy" wrote in message
...
Senario: The first working day of any year is the first Monday in the
year,
except where the 1st January is a Monday then the 8th January is the
first
working day.
Action: When any date is entered into A1 a formula in cell A2 returns
the
date of the first working day of that year.
Problem: I'm having difficulty developing a formula that produces a
correct
result whatever date is entered into A1.
Plea: I'm sure there must be a simple solution, but I've can't see the
wood
for the trees. Can anybody help please?

Try this:
=DATE(YEAR(A1),1,7-WEEKDAY(DATE(YEAR(A1),1,1),3)+1)