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.