View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Need Letters in the Columns Need Letters in the Columns is offline
external usenet poster
 
Posts: 7
Default 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.