Combine Date and Text Then Determine Last Day

[muhammad susanto]

hi all..

i'm looking for formula to figure out this case

start date	end date	desired result
Jan-2022	Jan-2022	period 31 January till 31 January 2022
Feb-2022	Jun-2022	period 1 February till 30 June 2022
Jan-2022	Jun-2022	period 1 January till 30 June 2022
etc..

start date & end date columns , input manually.
my target in desired result
anyone help me, thanks in advance.

.sst

 

[Peter_SSs]

Why does the first desired result start on the last day of the "start date" month and the other two rows start on the first day of the "start date" month?

 

[muhammad susanto]

hi peter, sorry, that not sequence date but sample...
perhaps for 1 sample like this:
start date
Jan 22
end date
Dec 22

expected result:
period 1 january till 31 December 2022

 

[Peter_SSs]

Is this what you mean then?

22 07 05.xlsm
	A	B	C
1	start date	end date	desired result
2	Jan-2022	Jan-2022	period 1 January till 31 January 2022
3	Feb-2022	Jun-2022	period 1 February till 30 June 2022
4	Jan-2022	Jun-2022	period 1 January till 30 June 2022
Combine text and dates

Cell Formulas
Range	Formula
C2:C4	C2	="period "&TEXT(A2,"d mmmm")&" till "&TEXT(EOMONTH(B2,0),"d mmmm yyyy")

 

[muhammad susanto]

hi Peter, quickly..That's i want it..
thank you very much.

 

[Peter_SSs]

You're welcome. Thanks for the confirmation.