create a worksheet that will list the days of the month

[AlanWade]

Hi,
I am trying to create a worksheet that will list the days of the month. By this what I am trying to say is at the moment if I enter the date lets say 01-06-08 in cell A1 the date is automatically filled out for the entire month. At the moment I have 30 cells below A1 with the formula A1 + 1, A2 + 1 etc. this works but as some months have less than 31 days it shows the first days of the next month which is not really what I want.
Can anybody help me please?

Thanks in advance
Alan

[NBVC]

Try in A2, copied down as far as you want...

=IF(A1="","",IF(MONTH(A1+1)<>MONTH($A$1),"",A1+1))

[AlanWade]

Thanks for the reply, the problem is my version of Excel is in Swedish and when I translate the English words over it wont work.
Thanks anyway for trying to help me.
Regards
alan