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 in Text String 1
Using Vlookup with multiple sheet 3
Reference a file by concatenating cell variables 13
How do I create a total sheet 2
Counting items with a specific quanitifier in a date range 3
SUMIF with date Question? - Maybe 5
Customise a Date to display as something else 2
Date Functions 5

Top