Time sheet Semi-monthly

Hi,

I am trying to create a Semimonthly time sheet, but I am facing a problem with the dates. Actually I am new at using Excel and don't have any idea how to automatically make the dates change, I am able to create from 1st to 15th but not from 16th to 31st. If any one have a sample time sheet for a semimonthly please help me out it's urgent.

Thank you
sri

Thread closed - duplicate post