How can we let our worksheet to determine the end of the month... eg..if I am creating in column A the daily dates... How can I let my worksheet to display the relevant dates only for the particular month .. ie.. January - up to 31/01/2007, February - up to 28/02/2007 and so forth...

P/S : For the months, I am using Data Validation to select month. So, I need my worksheet to be able to determine the last date of the month. I don't want to appear something like 31/02/2008...

On the other hand, how can we let the worksheet to display the day of the week in corresponding to the dates? For example : if the date changed to 01/12/2007 it will show Saturday.

Please advise.