If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
[newbie] copying a date value
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? |
#2
|
|||
|
|||
[newbie] copying a date value
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 "Jon" wrote in message ... 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? |
#3
|
|||
|
|||
[newbie] copying a date value
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? |
Thread Tools | |
Display Modes | |
|
|