copying a date into a text string

  • Thread starter Looking for help
  • Start date
L

Looking for help

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Date diffrence in days, weeks and months. 1
Date in Text String 1
count not-overlapping days in a "Table" with Beginning and EndingsDates Specified 0
Using Vlookup with multiple sheet 3
VBA - exporting serial letters to single documents 0
How to use/create code in MS Word to calculate age? 0
Conditional Formatting 1
using different sheets match string to specific work and enter that work in active 0

Top