Show Bi-Weekly Payday Dates for the Month

[osscie3]

Hi all,

Is there a way I can have the spreadsheet tell me which days will be payday for me? I'm on a bi-weekly/every other Friday schedule. Maybe have 3 (2 in most cases) cells that just show the date I'll be paid for the upcoming month?

For my personal budget I have a workbook in Excel and each sheet represents the month (so I have 12 sheets - Jan-Dec). I like to keep my old budget months for a year just to go back and analyze if need be.

To create the upcoming month (in this case June's budget), I basically just duplicate May's budget spreadsheet and delete the old June one.

 

[Dave Patton]

Edit the following for start date and ranges

T202002a.xlsm
	C	D	E
10	WEEK1	WEEK2	WEEK3
11	Fri Jan 01, 21	Fri Jan 15, 21	29-Jan-2021
12	Fri Feb 12, 21	Fri Feb 26, 21
13	Fri Mar 12, 21	Fri Mar 26, 21
14	Fri Apr 09, 21	Fri Apr 23, 21
15	Fri May 07, 21	Fri May 21, 21
16	Fri Jun 04, 21	Fri Jun 18, 21
4b

Cell Formulas
Range	Formula
D11:D16	D11	=C11+14
E11:E16	E11	=IF(C11+28>EOMONTH(C11,0),"",C11+28)
C12:C16	C12	=C11+28+(C11+28<=EOMONTH(C11,0))*14

 

[JamesCanale]

Excel 365?

MrExcelPlayground2.xlsm
	A	B
20	10/1/2021	Friday, October 1, 2021
21	10/31/2021	Friday, October 15, 2021
22		Friday, October 29, 2021
Sheet29

Cell Formulas
Range	Formula
B20:B22	B20	=FILTER(SEQUENCE(A21-A20+1,1,A20,1),INT((SEQUENCE(A21-A20+1,1,A20,1)-6)/14)-(SEQUENCE(A21-A20+1,1,A20,1)-6)/14=0,"")
A21	A21	=EOMONTH(A20,0)
Dynamic array formulas.

The two "-6" become "+1" if you get paid the other Friday.