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