Okay, anyone got a recommendation on perhaps a custom format that will allow you to utilize a concatenate formula to pull in a date and title of something and the date appear as a date?
I am essentially creating a primary key that I want to user to be able to recognize as a current activity. I want to utilize the Date as the primary factor in the naming. So right now I have the formula pointed to a column with a activity date that will be referenced. However, when the result returns excel is formatting date into a numeric value and not date format.
Example Formula = =IF((B2 = ""),"",CONCATENATE(I2," - ",B2))
- I2 is the Activity Date
- B2 is Customer Name
Result = 40855 - TE Enterprise
I am essentially creating a primary key that I want to user to be able to recognize as a current activity. I want to utilize the Date as the primary factor in the naming. So right now I have the formula pointed to a column with a activity date that will be referenced. However, when the result returns excel is formatting date into a numeric value and not date format.
Example Formula = =IF((B2 = ""),"",CONCATENATE(I2," - ",B2))
- I2 is the Activity Date
- B2 is Customer Name
Result = 40855 - TE Enterprise