Hi!

I am currently creating a time sheet for our employees in Excel. Employees hand in their time sheets twice a month - the 15th (for period 1st-15th) and the last day of the month (for period 16th-29th/30th/31st). I have entered formulas so all the employee has to do is enter the pay period start date and Excel automatically populates the pay period end date, the "Day" column and the "Date" column.

This works out PERFECT for a month with exactly 30 days. Is there anyway to tell Excel to add that extra row to adjust for months that have 29 or 31 days?

Any help would be much appreciated!! Thank you!!

Attached Images

Screen Shot 2014-04-07 at 12.30.33 PM.png (54.8 KB, 19 views)

Hi
could you please post a sample sheet (not a pic) please?

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

yup! see attached....

Attached Files

Timesheet Template1.xlsx (16.2 KB, 9 views)

Presumbaly, you also won't want people inputting anything on 30 February - ever - or 29 February in most years...

The only way you can conditionally display/hide such rows (which doesn't stop people inputting data into them) or add/delete such rows (which does stop people inputting data into them) is via a macro. Such a macro can be tied to workbook opening, so that it checks the date and adds/deletes rows as applicable.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

If you can live with some blank rows, the attached should get you on track

Attached Files

Timesheet Template1.xlsx (16.4 KB, 12 views)

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Thank you SO much! The timesheet looks great and works out awesome!

I really appreciate the time you put into this...thank you thank you!!

NP I added some data validation in cell D5. Hover over the cell and try entering a wrong date

Attached Files

Timesheet Template1.xlsx (16.6 KB, 16 views)

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

that looks great! thank you so much!