Probleme with a calculated column that does not exist [Sharepoint list]

Yannick CRETON 1 Reputation point

Hi there,

I'm struggling to apply a simple formula to a column in a list of sharepoint 365.

I want to extract the number associated to the month from a date column.

The name of my column is "Birthday 1". So I tried to use this formula in a calculated column :

=TEXT([Birthday 1],"mm")

But I have the error message telling me that the column ( Birthday 1) does not exist.

I know that usually theses formulas don't like spaces, so I tried to remove it but this doesn't solve the problem.

I've read online that deleting and recreate the column might be a solution but this column is full of handwritted information that I don't want to wrote again.

The only way to clone a column ( it also might be a solution ) is to us calculated column, which is impossible for me.

I'm really stuck here and don't know what to do. If there is no solution I'll recreate the column but I would like to find an easier solution.

If anybody has a clue please help.

Best regards,


A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
9,211 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. JoyZ 18,031 Reputation points

    @Yannick CRETON ,

    This has nothing to do with spaces, double-click the column to insert it, and then fill in the formula:


    If an Answer is helpful, please click "Accept Answer" and upvote it.

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.