On Fri, 4 Jul 2008 06:53:39 -0700 (PDT), AMaleThing wrote:

Is there a forumla to enter into a cell which can report for e.g.

a) the date of the first monday of the month?
b) the first working day of the week?

Much appreciated.

With some date in A1:

First Monday:

=A1-DAY(A1)+8-WEEKDAY(A1-DAY(A1)-1)

And, requiring either Excel 2007 or installation of the Analysis ToolPak for
earlier versions of Excel:

first working day of the week:

=WORKDAY(A1-WEEKDAY(A1),1,Holidays)

where Holidays is a range where your holiday dates are stored.

First working day of the month:

=WORKDAY(A1-DAY(A1),1)
--ron