How to Automatically Add/Delete Columns Based On Information

kconnolly · #1 04-07-2014, 09:40 AM

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!!

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Find and Delete Rows based on a range	damaniam	Excel Programming	2	03-12-2014 06:06 AM
Match information from 2 different columns	gbaker	Excel	2	08-18-2012 06:07 PM
Automatically inserting information into report	joughin	Word	3	05-15-2012 09:12 PM
how to create two columns based on a certain criterior from the original two column?	where_pc	Excel	3	06-13-2011 10:39 AM
Add/Delete data in a Document based on User info	vishal17	Word	5	04-14-2011 05:02 PM