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