|
|
#1
04-07-2014, 09:40 AM
|
|||
|
|||
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!! 
|
|
|
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 |
Mac OS X 
Office 2013
Threaded Mode