| 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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Merge two cells with dates to create a date range
=TEXT(A2,"m/dd/yy")&"-"&TEXT(B2,"m/dd/yy")
but please don't merge cells. Concatenating the contents is fine, but merging cells causes countless problems (as the archives of the group will show). -- David Biddulph "Need Letters in the Columns" wrote in message ... 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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Merge two cells with dates to create a date range
Thank you if worked perfect.
"David Biddulph" wrote: =TEXT(A2,"m/dd/yy")&"-"&TEXT(B2,"m/dd/yy") but please don't merge cells. Concatenating the contents is fine, but merging cells causes countless problems (as the archives of the group will show). -- David Biddulph "Need Letters in the Columns" wrote in message ... 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. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Merge two cells with dates to create a date range
Try it this way:
=TEXT(A2,"m/dd/yy")&"-"&TEXT(B2,"m/dd/yy") then copy it down. Hope ths helps. Pete On Jan 27, 8:51*pm, Need Letters in the Columns wrote: 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. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Merge two cells with dates to create a date range
Thank you it worked perfect.
"Pete_UK" wrote: Try it this way: =TEXT(A2,"m/dd/yy")&"-"&TEXT(B2,"m/dd/yy") then copy it down. Hope ths helps. Pete On Jan 27, 8:51 pm, Need Letters in the Columns wrote: 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. |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Merge two cells with dates to create a date range
You're welcome - thanks for taking the trouble to feed back.
Pete On Jan 28, 2:35*pm, Need Letters in the Columns wrote: Thank you it worked perfect. |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Merge two cells with dates to create a date range
Use
=text(A1,"mm/dd/yyyy") & "-" & text (B1,"mm/dd/yyyy") Text() will convert the dates to text and then concatenate "Need Letters in the Columns" wrote: 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. |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Merge two cells with dates to create a date range
Thank you it worked perfect. "Sheeloo" wrote: Use =text(A1,"mm/dd/yyyy") & "-" & text (B1,"mm/dd/yyyy") Text() will convert the dates to text and then concatenate "Need Letters in the Columns" wrote: 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. |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Merge two cells with dates to create a date range
=TEXT(A2,"mm/dd/yy")&" - "&TEXT(B2,"mm/dd/yy")
Gord Dibben MS Excel MVP On Tue, 27 Jan 2009 12:51:02 -0800, Need Letters in the Columns wrote: 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. |
|
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Merge two cells with dates to create a date range
Thank you it worked perfect.
"Gord Dibben" wrote: =TEXT(A2,"mm/dd/yy")&" - "&TEXT(B2,"mm/dd/yy") Gord Dibben MS Excel MVP On Tue, 27 Jan 2009 12:51:02 -0800, Need Letters in the Columns wrote: 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. |
| Reply |
| 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 | |||
Hybrid Mode
