Formula using formatted dates

C

cvgairport

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
 
P

Peo Sjoblom

=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
 

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


Top