On 4 Jul, 16:19, "Rick Rothstein \(MVP - VB\)"
wrote:
If A1 contains any date within the month, then the first Monday of that
month can be found with this formula....

=A1-DAY(A1)+1+CHOOSE(WEEKDAY(A1-DAY(A1)+1),1,0,6,5,4,3,2)

Rick

"AMaleThing" wrote in message

...



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.- Hide quoted text -

- Show quoted text -

Starting with the simpiest looking formulas, I'm trying:
=A1+MOD(8-WEEKDAY(A1,2),7)

Can you help me to understand why 8 is subtracted from WEEKDAY?