I would like to format a new column with the Month and Day of another column. Is there a way to accomplish this? I tried adding this =TEXT([Date of Birth],"MM/DD") in column validation but it gives me the following error.

The formula cannot refer to another column. Check the formula for spelling mistakes or update the formula to reference only this column.

2 Answers 2


You would need to get the month and day components separately and combine, something like:

=CONCATENATE(MONTH([Date of Birth), "/", DAY([Date of Birth]))

Where did you put the formula? The TEXT() function should work fine in a calculated column but you would get the error you indicate in the default value of a field.

  • Sorry for the delay in response. I figured out the issue, I didn't make the new column a calculated column. Duh!
    – meepmeep
    Dec 16, 2013 at 20:09

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.