Jake,
Thanks for you help. I got this to work fine. I have more problems with this
project that I'm going to post but this is great.
Here's how it ending up looking.
=TEXT("Month End","@")&" "&TEXT(A1,"mm/dd/yy")&" "&TEXT(A2,"000000")&" -
"&TEXT(A3,"000000")
Output looks like this.
Month End 08/31/00 000241 - 208003
I didn't use your formula of Date because the user is selecting the date
from the datalist.
Thanks again.

--
jeffP


"Jake Marx" wrote in message
...
Hi jeffP,

jeffP wrote:
I actually have columns Cust,Inv,Date. The output cell I want is "
Month End" <date , <cust-inv. You showed me the cust-inv
concatenate. The "month end" constant I got in (if not very
elegantly) by entering it a remote cell and referring to it (is there
a better way?). My problem is that date is formatted as date
(mm/dd/yy) in the original cell and when I refer to it , it comes in
as the underlying numeric.
I.e.: =Text(C1,"000000") shows 38232 instead of the desired 09/02/04.

If you want the month end date for the *current* month, you could use
something like this in your formula:

=TEXT(DATE(YEAR(TODAY()),MONTH(TODAY())+1,0),"mm/dd/yy")

If you want a different month end, you could substitute the date for each
occurence of TODAY().

--
Regards,

Jake Marx
MS MVP - Excel
www.longhead.com

[please keep replies in the newsgroup - email address unmonitored]