| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Return a different date format
Hi
Can anyone help me with this? What i want to do is to take part of two dates and ,a name and combine them into a string. In other words,I want to take the day and month from column A (3101)and B (2410) and the first 4 letters from A (Main) to produce the invoice no D (31012401 Main) A B C D Site From To Invoice no. Main St 31-Jan-08 24-Oct-07 31012401 Main I would be most grateful for suggestions. thanks David |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Convert date + time text format to date format | Excel Worksheet Functions | |||
| I want my combo box to return a date format instead of a number? | Excel Discussion (Misc queries) | |||
| using lookup to return more than one answer in date format | Excel Worksheet Functions | |||
| Date formula: return Quarter and Fiscal Year of a date | Excel Discussion (Misc queries) | |||
| Excel 2000 date format cannot be set to Australian date format | Excel Discussion (Misc queries) | |||
Threaded Mode
