Dat formatting in a formula

Experts, how would I format the 'Date Entry'!D23  to date format?  

="for the period between " &'Date Entry'!D23 & "and " &'Date Entry'!E23

the output is like so:
for the period between 42542and 42724


thank you
pdvsaProject financeAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
D PatelConnect With a Mentor D Patel, Software EngineerCommented:
Try This :

="for the period between " & TEXT('Date Entry'!D23, "dd/mm/yyyy") & " and " & TEXT('Date Entry'!E23, "dd/mm/yyyy")
0
 
pdvsaProject financeAuthor Commented:
perfect.  thank you
0
All Courses

From novice to tech pro — start learning today.