Can you please help me? I have this timesheet (see attached) everything is formulated but the date. I am trying to figure out how to enter a formula to calculate the bi-weekly pay-period in excel. For example: Pay period begins on 2/1/16 and ends on 2/15/16 then it starts again 2/16/16 then ends on 2/29/16. What I would like to happen is when the pay period begins on a different day of the week instead of a first day of the week it will automatically enter the date on the day. Then if possible the date can be at max meaning whatever the pay period ended the date should not continue on the next day. I'm not sure if I am making sense.

Attached Files

Timesheet.xlsx (16.6 KB, 20 views)