Hi There,

Select 6*7 range and enter array-formula (Honours to Jwalk!)
Put in B6 a day in month of may 2005.

You'll see 1st may is missing! Possible to get it in somehow?


=IF(MONTH(DATE(YEAR(B6);MONTH(B6);1))-
MONTH(DATE(YEAR(B6);MONTH(B6);1)-
(WEEKDAY(DATE(YEAR(B6);MONTH(B6);1))-2)+
{0;1;2;3;4;5}*7+{1\2\3\4\5\6\7}-1);"";DATE(YEAR(B6);
MONTH(B6);1)-(WEEKDAY(DATE(YEAR(B6);
MONTH(B6);1))-2)+{0;1;2;3;4;5}*7+{1\2\3\4\5\6\7}-1)

PS. US-XLversions will need to replace ; by , and / by ;

Cheers Sige