| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Merge two cells with dates to create a date range
Hello, I would like to Merge to cells with dates to create a date range example
A B c dstartdate denddate Date Range 8/25/2008 9/21/2008 8/25/09-9/21/08 If I use the formula =A2&"-"&B2 I have to put a (') in front of each date in column A and B otherwise it comes out as unformatted numbers and I can't use the format to date to fix it. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Identifying unique dates in a range of cells containing dates... | Excel Discussion (Misc queries) | |||
| Identifying unique dates within a range of cells containing dates | Excel Discussion (Misc queries) | |||
| return a date from range, date is between dates in two other cells | Excel Discussion (Misc queries) | |||
| Create Excel Grouping according to Merge Cells | Excel Worksheet Functions | |||
| How to count dates within a certain range in a column with mutiple date range entries | Excel Worksheet Functions | |||
Threaded Mode
