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

howard

Well-known Member
Joined
Jun 26, 2006
Messages
5,686
Office Version
  1. 2019
Platform
  1. Windows
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

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


It would be appreciated if someone could amend my formula
 

Some videos you may like

Excel Facts

Best way to learn Power Query?
Read M is for (Data) Monkey book by Ken Puls and Miguel Escobar. It is the complete guide to Power Query.

howard

Well-known Member
Joined
Jun 26, 2006
Messages
5,686
Office Version
  1. 2019
Platform
  1. Windows
Thanks, formula works perfectly
 

Watch MrExcel Video

Forum statistics

Threads
1,118,751
Messages
5,574,018
Members
412,563
Latest member
marianmalone2019
Top