Start date and End date in a calendar

[elynoy]

Hello, I use this formula

=DATA(M2;D2;1)

and this one too

=SE(H6<>"";SE(MÊS(H6)<>MÊS(H6+1);"";H6+1);"")

to retrieve the start date and the end date of the month.

How can i make it start on day 25 and go till day 26 of the next month since the formula hides the days if the months has one day less or more like february?

Best regards,
eLy

 

[elynoy]

I tried

"=SE(A2="26";=EOMONTH(DATE(A14,B14,1),-1)+26;EOMONTH(DATE(A14,B14,1),-1)+26)

but no matter what I change in the second part of the formula it wont work

 

[elynoy]

I figured it out. seems I cant use the "" in threre. anyway I got a working exemple for better understanding.

https://ufile.io/kwa01od7

if it put in cell B4, the day 26 it works. starts at 26 and finishes at 25 and the next month it repeats.

but if I start at day 25 for exemple, it repeats that day at the end and at the begining of the next month.

Not sure If I'm explainign myself good enought.

best regards,
eLy

 

[Aryatect]

Sure ely,

Modified to refer to a cell for a start date. End date will be start date -1:

Book1
	A	B	C	D	E	F	G	H	I
12	Start Date	26	assuming end date =B12-1
13	Year	Month	Day 1	Day 2	Day 3	Day 4	Day 5	Day 6	Day 7
14	2019	7	7/26	7/27	7/28	7/29	7/30	7/31	8/1
15	2019	8	8/26	8/27	8/28	8/29	8/30	8/31	9/1
16	2019	9	9/26	9/27	9/28	9/29	9/30	10/1	10/2
17	2019	10	10/26	10/27	10/28	10/29	10/30	10/31	11/1
18	2019	11	11/26	11/27	11/28	11/29	11/30	12/1	12/2
19	2019	12	12/26	12/27	12/28	12/29	12/30	12/31	1/1
Sheet3

Cell Formulas
Range	Formula
C14	=EOMONTH(DATE(A14,B14,1),-1)+$B$12
D14	=IFERROR(IF(MONTH($C14)=MONTH(C14+1),C14+1,IF(DAY(C14+1)<=$B$12-1,C14+1,"")),"")

 

[elynoy]

Thank you! it's working like a charm now!

best regards,
eLY

 

[Aryatect]

Glad could help, thanks for the feedback