Dare Format
Trying to concatenate two dates with a "To" between to show a beginning and
Ending date. Unfortunately, Excel keeps posting the dates as a serial number. Since this is to be presented to a customer that will not work. I need the dates in 06/13/2006 to 06/12/2007 format. I am using the formula below. I have tried to change the number format using the Format Cells - Number - Date and General and Text settings, none of which work... can anyone assist? =IF('Service Renewal raw'!AA4="","",IF('Service Renewal raw'!AB4="","",CONCATENATE('Service Renewal raw'!AA4, " to ",'Service Renewal raw'!AB4))) Thanks, Don |
Dare Format
|
Dare Format
|
Dare Format
|
All times are GMT +1. The time now is 04:14 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com