Formula to insert 01/10 and extract year from Cell L1 (Format dd/mm/yyyy)

[howard]

I have tried to set up a formula to show the date as 01/10 and year to be extracted from Cell L1. The format for the date is dd/mm/yyyy

L1 is 2020 so I want formula to display 01/10/2020 (it will always be 01/10 and then whatever the year is in L1

=DAY("01")&"/"&MONTH("10")&"/"&YEAR(L1)

It would be appreciated if someone could amend my formula

 

[Tetra201]

Try

=DATE(L1,10,1)

and format the cell as dd/mm/yyyy

 

[howard]

Thanks, formula works perfectly

 

[Tetra201]

You are welcome.

 

[Dave Patton]

T202010b.xlsm
	L	M
1	2020	1-Oct-20
2	2021	1-Oct-21
3
2b

Cell Formulas
Range	Formula
M1	M1	=--("01/10/"&L1)
M2	M2	=--("01-10-"&L2)

 

[howard]

Thanks for the help