I'm trying to get the date value in dddd dd/mm/yyyy format, however, when
using this formula, the date returned seems to be the "excel serial number":

="Payslip period from"&" "&'Current payroll'!$B$3 & " to " & 'Current
payroll'!D3

Returns: Payslip period from 39895 to 39908, whilst I would like to copy
23/03/2009 and 05/04/2009 respectively.

Any idea how to convert the format?