Semi-Monthly Pay Date Schedule ( 1st and 15th)

[tecco360clean]

I am looking for an excel template to run Semi-Monthly Pay dates such as..

Pay Date	Start	End
2/1/2019	1/14/2019	1/27/2019
2/15/2019	1/28/2019	2/13/2019
3/1/2019	2/14/2019	2/27/2019

[avk]

Are you required auto calculate pay date? If yes.
Suppose start date in cell "A2" & end date in cell "B2"
In "C2" (Pay Date) formula is

Please Login or Register  to view this content.

Copy paste down.

[FlameRetired]

Hello tecco360clean. Welcome to the forum.

This formula is a bit long. Perhaps someone will come up with a simpler/shorter one.

It must be array entered in B1 (as below layout) and filled down.

If you aren’t familiar with array-entered formulas array enter means the formula must be committed from edit mode by simultaneously pressing and holding down Ctrl and Shift while hitting Enter.

Please Login or Register  to view this content.

	A	B	C
1	1/27/2019	2/1/2019
2	2/13/2019	2/15/2019
3	2/27/2019	3/1/2019
4
5