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.
|