Formula using formatted dates
 

Hi there,

I was wondering if you could use a concatenation formula with a date that is
formatted and still retain the formatted structure.

In one cell I have a date of 1/15/2008 formatted to show Jan-08. I want to
use this date and attach to the end "YTD". I would like the cell to show
Jan-08 YTD. Is that possible?

Thanks!

Amy

Formula using formatted dates
 

Custom format:

mmm-yy" YTD"
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"cvgairport" wrote in message
...
Hi there,

I was wondering if you could use a concatenation formula with a date that
is
formatted and still retain the formatted structure.

In one cell I have a date of 1/15/2008 formatted to show Jan-08. I want
to
use this date and attach to the end "YTD". I would like the cell to show
Jan-08 YTD. Is that possible?

Thanks!

Amy

Formula using formatted dates
 

=TEXT(A1,"mmm-yy")&" YTD"

where A1 holds the date, of course you could format it directly as well

mmm-yy "YTD"




--


Regards,


Peo Sjoblom

"cvgairport" wrote in message
...
Hi there,

I was wondering if you could use a concatenation formula with a date that
is
formatted and still retain the formatted structure.

In one cell I have a date of 1/15/2008 formatted to show Jan-08. I want
to
use this date and attach to the end "YTD". I would like the cell to show
Jan-08 YTD. Is that possible?

Thanks!

Amy

Formula using formatted dates
 

Try this:

=IF(A1="","",TEXT(A1,"mmm-yy")&" YTD")

--
Biff
Microsoft Excel MVP


"cvgairport" wrote in message
...
Hi there,

I was wondering if you could use a concatenation formula with a date that
is
formatted and still retain the formatted structure.

In one cell I have a date of 1/15/2008 formatted to show Jan-08. I want
to
use this date and attach to the end "YTD". I would like the cell to show
Jan-08 YTD. Is that possible?

Thanks!

Amy

Formula using formatted dates
 

They all worked - thanks

"T. Valko" wrote:

Try this:

=IF(A1="","",TEXT(A1,"mmm-yy")&" YTD")

--
Biff
Microsoft Excel MVP


"cvgairport" wrote in message
...
Hi there,

I was wondering if you could use a concatenation formula with a date that
is
formatted and still retain the formatted structure.

In one cell I have a date of 1/15/2008 formatted to show Jan-08. I want
to
use this date and attach to the end "YTD". I would like the cell to show
Jan-08 YTD. Is that possible?

Thanks!

Amy

Formula using formatted dates
 

And we all appreciate the feed-back.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"cvgairport" wrote in message
...
They all worked - thanks

"T. Valko" wrote:

Try this:

=IF(A1="","",TEXT(A1,"mmm-yy")&" YTD")

--
Biff
Microsoft Excel MVP


"cvgairport" wrote in message
...
Hi there,

I was wondering if you could use a concatenation formula with a date
that
is
formatted and still retain the formatted structure.

In one cell I have a date of 1/15/2008 formatted to show Jan-08. I
want
to
use this date and attach to the end "YTD". I would like the cell to
show
Jan-08 YTD. Is that possible?

Thanks!

Amy