| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula to count number of time stamps within a range in a column having dates formatted as "custom" | Excel Discussion (Misc queries) | |||
| How do I sort dates that are not formatted correctly? | Excel Discussion (Misc queries) | |||
| dates automatically formatted wrong | Excel Discussion (Misc queries) | |||
| Dates formatted as text | Excel Discussion (Misc queries) | |||
| Dates in Excel - yyyymmdd, not formatted, how do I format this? | Excel Discussion (Misc queries) | |||
Hybrid Mode
