| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Date Text
Hello,
This formula: =TEXT(B282,"mmm d")& " - " &TEXT(B306,"mmm d") To produce the following: Jan 2 - Jan 6 What I would like to do is have the result show this: Week of Jan 2 - Jan 6 Thanks for the help. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I convert a text string into a date? | Excel Worksheet Functions | |||
| Converting number or text to a Date Format | New Users to Excel | |||
| Macro to convert text to date | Excel Worksheet Functions | |||
| Change Text Data to Date | Excel Discussion (Misc queries) | |||
| EXTRACT TEXT FROM A DATE | Excel Worksheet Functions | |||
Threaded Mode
