I've had a look at Chip's site and think the answer to my problem will
lie in a Networkdays formula, but don't _know_. So...

Cells A3-A7 are Mon, Tues... Fri
Cell A1 contains the month, B1 the year.

What I want to do is see what day the 1st of the month falls on. I then
want to zero out all days prior to that in column B. From the 1st
onwards, I want to be able to input data.

So, for example, September 05 would look like:

A B
September 2005

Mon 0
Tues 0
Weds 0
Thurs
Fri

If the 1st was a Monday, as it is this month, for example, I would want
all B3-B7 left clear for input.

Does anyone know how I would do this?

Thanks in advance

Steve