Hi Sige

The formula I posted for you on 20/09 does work for every month except May.
I had not tested that.
Bernie, changing the sequence from 1/2/3/4/5/6/7 to 0/1/2/3/4/5/6 has
achieved it working for May, but has put the starting day back to Sunday.

I had ameneded the 2 parts of the formula
(WEEKDAY(DATE(YEAR(A1),MONTH(A1),1))-1)

to (WEEKDAY(DATE(YEAR(A1),MONTH(A1),1))-2) in order to get it to start Mondays.

Changing the new formula from
(WEEKDAY(DATE(YEAR(A1),MONTH(A1),1))-2)
to
(WEEKDAY(DATE(YEAR(A1),MONTH(A1),1))-3)
puts it back to starting Monday, but the problem of 1st May 2005 returns.

I can't see how to solve this at the moment. It appears that as long as you
start the week on Sundays, it will always work (with either vesion of the
formula), but it is trying to make the weks start on Monday gives the problem.


Regards

Roger Govier


wrote:
Hi Bernie,

May has also 1st! yipie...

But how to Mondays as my first column? While maintaining 1st may!

Cheers Sige