| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
copying a date into a text string
I have a date in cell b6 (format is custom m/d/yyyy) input value is 08/23/08
In column E18, I have a formula "b6-5" (format is custom m/d;@), the purpose of this is that the b6 date is a week ending date and e18 is the actual day of the week. Output value is 08/18 In cell a125, I am trying to get 08/18 to display as part of a sentence using the following string "="that during the payroll period commencing on "&$E$18", but what I get is this that during the payroll period commencing on 39606 What I would like to see is this that during the payroll period commencing on 08/18 I know that there is something wrong with my string, but I am not sure how to correct it, any help would be greatly appreciated. Thank you |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
copying a date into a text string
Just use TEXT to format it likewise
In A125: ="that during the payroll period commencing on "&TEXT($E$18,"m/d;@") -- Max Singapore http://savefile.com/projects/236895 Downloads:17,800 Files:359 Subscribers:54 xdemechanik --- "Looking for help" wrote: I have a date in cell b6 (format is custom m/d/yyyy) input value is 08/23/08 In column E18, I have a formula "b6-5" (format is custom m/d;@), the purpose of this is that the b6 date is a week ending date and e18 is the actual day of the week. Output value is 08/18 In cell a125, I am trying to get 08/18 to display as part of a sentence using the following string "="that during the payroll period commencing on "&$E$18", but what I get is this that during the payroll period commencing on 39606 What I would like to see is this that during the payroll period commencing on 08/18 I know that there is something wrong with my string, but I am not sure how to correct it, any help would be greatly appreciated. Thank you |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
copying a date into a text string
Thank you for your help, it worked perfectly!
"Max" wrote: Just use TEXT to format it likewise In A125: ="that during the payroll period commencing on "&TEXT($E$18,"m/d;@") -- Max Singapore http://savefile.com/projects/236895 Downloads:17,800 Files:359 Subscribers:54 xdemechanik --- "Looking for help" wrote: I have a date in cell b6 (format is custom m/d/yyyy) input value is 08/23/08 In column E18, I have a formula "b6-5" (format is custom m/d;@), the purpose of this is that the b6 date is a week ending date and e18 is the actual day of the week. Output value is 08/18 In cell a125, I am trying to get 08/18 to display as part of a sentence using the following string "="that during the payroll period commencing on "&$E$18", but what I get is this that during the payroll period commencing on 39606 What I would like to see is this that during the payroll period commencing on 08/18 I know that there is something wrong with my string, but I am not sure how to correct it, any help would be greatly appreciated. Thank you |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
copying a date into a text string
Welcome
-- Max Singapore http://savefile.com/projects/236895 Downloads:17,700 Files:359 Subscribers:55 xdemechanik --- "Looking for help" wrote in message ... Thank you for your help, it worked perfectly! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Date in Text String | Excel Worksheet Functions | |||
| Date format in a text string | Excel Worksheet Functions | |||
| Transpose a text string while copying adjacent column data to new | Excel Worksheet Functions | |||
| Convert text string to date | Excel Worksheet Functions | |||
| How do I convert a text string into a date? | Excel Worksheet Functions | |||
Linear Mode
