[newbie] copying a date value

[Jon]

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?

 

[francis]

Hi
Try this

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


--
Hope this help

Pls click the Yes button below if this post provide the answer you asked


cheers, francis

 

[Jacob Skaria]

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