Ron@Buy,

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.

The solution you choose is of course a matter for yourself but 1/1/2007 was
a Monday so according to your logic above for any date in 2007 (or 2001)
entered into A1 the formulas hould return 8/1/ of that year

Avri's excellent and compact formula; which is far superior to my unwieldy
one both return this the other sadly does not.

Mike


"Ron@Buy" wrote:

Mike
Thanks for your response - your effort was much shorter than my attemps but
unfortunately like mine produced an incorrect result (should return first
date of first Monday of the year, except Jan 1) when different dates are
entered.
Arvi
Thanks for your response - much shorter than Mike's but again unfortunately
didn't return date of first Monday when different dates are entered.
Stephen
Thanks for your response - BRILLIANT, works perfectly every time - I thought
there ought to be a genius out there somewhere.


"Mike H" wrote:

When I said simpler, I didn't think that much simpler!! Excellent.

"Arvi Laanemets" wrote:

Hi

With Analysis Toolpack Add-In activated
=WORKDAY(DATE(YEAR(A1),1,0),1,DATE(YEAR(A1),1,1))


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



"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?