Cut-Off Date *Problem

[Elijah1213]

Hello, I would like to ask if there is formula for the auto fill for this cut-off table? Row 2 and the rest is the format and I like to auto fill this and have same result. Thanks.

 

[awoohaw]

this seems to be an exact copy of this question, but made by a different person:

Payroll period in excel (Bi-Monthly cut off)

Hi, what formula can I use to auto-fill like this in rows 31 to 34? I would like to auto-fill up this cut-off until in last month of the year and same as to the release date which is 5 days duration. Thanks.

www.mrexcel.com

The suggestion I made there is:

Book1
	A	B	C
30	Period Line/Start Date	Period Line/End Date	Period Line/Release Date
31	2024-01-01	2024-01-15	2024-01-20
32	2024-01-16	2024-01-31	2024-02-05
33	2024-02-01	2024-02-15	2024-02-20
34	2024-02-16	2024-03-01	2024-03-06
35	2024-03-01	2024-03-15	2024-03-20
Sheet2

Cell Formulas
Range	Formula
B31:B35	B31	=IF(DAY(A31+14)>15,EOMONTH(A31,0),A31+14)
C31:C35	C31	=B31+5
A32:A35	A32	=IF(DAY(A31)=1,A31+15,EOMONTH(A31,0)+1)