Semi monthly date group for a particular date

[DPK2088]

Hi,

Looking for an excel formula/coding, to get semi monthly paygroup for a particular date.

For example,

If I enter 07/23/2018(A1), the semimonthly date group should reflect 07/16/2018(B1) 07/31/2018(C1)

Thank You,

 

[DPK2088]

Additionally

IF I enter 01/12/2018 in (A1), the result should be 01/01/2018 (B1) to 01/15/2018 (C1) and so on

 

[Dave Patton]

Excel 2010
	A	B	C
1	23-Jul-18	16-Jul-18	31-Jul-18
2	5-Jul-18	1-Jul-18	15-Jul-18
3
6d

Cell Formulas
Range	Formula
B1	=IF(DAY(A1)>15,DATE(YEAR(A1),MONTH(A1),16),EOMONTH(A1,-1)+1)
B2	=IF(DAY(A2)>15,DATE(YEAR(A2),MONTH(A2),16),EOMONTH(A2,-1)+1)
C1	=IF(DAY(A1)>15,EOMONTH(A1,0),DATE(YEAR(A1),MONTH(A1),15))
C2	=IF(DAY(A2)>15,EOMONTH(A2,0),DATE(YEAR(A2),MONTH(A2),15))