Dear Jon

Use the TEXT function to conver a serial number date to any date format.

="Payslip period from "& TEXT('Current payroll'!B3,"dddd dd/mm/yyy") & " to
" &
TEXT('Current payroll'!D3,"dddd dd/mm/yyyy")

If this post helps click Yes
---------------
Jacob Skaria


"Jon" wrote:

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?