| 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 |
| 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) | |||
Threaded Mode
