Time sheet Semi-monthly

Hi,

Thank you for your quick reply, I am attaching the file that I am working on. If I enter the date as 11/16/2008 then the last cell is showing 12/1/2008 because november has 30 days only so I want a time sheet which can automatically calculate the days in the particular month and produce the time sheet accordingly. I have tried in many ways but I was suggested to use Macro's and I don't have any idea on this topic. So it would be great if you could suggest me some solution.

Thank you
Sri