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

Question

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,

Yannick.

Answer 1

@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.