[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? |
[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? |
[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? |
All times are GMT +1. The time now is 09:50 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com