Make Month start on 26th and end on 25th of the next month

[Andy1990]

Hi Team,

Was looking to create a payroll that allows Users to select a month, and that will prefill a column thats starts on the 26th of that month and end on the 25th of the following month.

I.e Users can select C1 and the Date on Column B prefills from the 26th of that month to the 25th of the following month.

Any help would be appreciated.

 

[Andy1990]

Disregard, i may have figured it out.

I used the following:
=DATE(C$2,C$1,1)+25

Unless there is a better way of doing it.

However, if for example the last cell goes past the EOM pay cycle (i.e i start on 26/09/2023 and page ends on 26/09/2023) - is there a way to make it blank? either via formula or conditional formatting

 

[Andy1990]

Disregard, i may have figured it out.

I used the following:
=DATE(C$2,C$1,1)+25

Unless there is a better way of doing it.

However, if for example the last cell goes past the EOM pay cycle (i.e i start on 26/09/2023 and page ends on 26/09/2023) - is there a way to make it blank? either via formula or conditional formatting

View attachment 94732

Apologies i meant start 26/09 and end 26/10 in this example

 

[bebo021999]

Book1
	A	B	C
1			9
2			2023
3
4		26/09/2023
5		27/09/2023
6		28/09/2023
7		29/09/2023
8		30/09/2023
9		01/10/2023
10		02/10/2023
11		03/10/2023
12		04/10/2023
13		05/10/2023
14		06/10/2023
15		07/10/2023
16		08/10/2023
17		09/10/2023
18		10/10/2023
19		11/10/2023
20		12/10/2023
21		13/10/2023
22		14/10/2023
23		15/10/2023
24		16/10/2023
25		17/10/2023
26		18/10/2023
27		19/10/2023
28		20/10/2023
29		21/10/2023
30		22/10/2023
31		23/10/2023
32		24/10/2023
33		25/10/2023
34		26/10/2023
35
36
37
38
39
40
41
42
Sheet1

Cell Formulas
Range	Formula
B4	B4	=DATE($C$2,$C$1,26)
B5:B29	B5	=B4+1
B30:B36	B30	=IF(B29="","",IF(DAY(B29)=26,"",B29+1))

 

[Peter_SSs]

Not quite following your messages about where to end, but what about this?

23 07 05.xlsm
	B	C
1		9
2		2023
3
4	26/09/23
5	27/09/23
6	28/09/23
7	29/09/23
8	30/09/23
9	1/10/23
10	2/10/23
11	3/10/23
12	4/10/23
13	5/10/23
14	6/10/23
15	7/10/23
16	8/10/23
17	9/10/23
18	10/10/23
19	11/10/23
20	12/10/23
21	13/10/23
22	14/10/23
23	15/10/23
24	16/10/23
25	17/10/23
26	18/10/23
27	19/10/23
28	20/10/23
29	21/10/23
30	22/10/23
31	23/10/23
32	24/10/23
33	25/10/23
34
Dates

Cell Formulas
Range	Formula
B4:B33	B4	=LET(s,DATE(C2,C1,26),SEQUENCE(EDATE(s,1)-s,,s))
Dynamic array formulas.