View Single Post
 
Old 04-07-2014, 09:40 AM
kconnolly kconnolly is offline Mac OS X Office 2013
Novice
 
Join Date: Apr 2014
Posts: 4
kconnolly is on a distinguished road
Default How to Automatically Add/Delete Columns Based On Information

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
File Type: png Screen Shot 2014-04-07 at 12.30.33 PM.png (54.8 KB, 21 views)
Reply With Quote