I want to display birthdays this month from list items.
I have a form where we add birthdays manual. This just for Jubilee birthdays (50/65, big thing in Sweden)
Since there is a lot of hits when googling this problem and no solution that works.
But from some guides I tried to compare columns with no luck.
From birthday date I have a calculated column that takes out month (MMMMM) so i get "november" in an Single line output.
I have done the same with todays Date and there i got the same calculated that gives me month in a Single line output.
Then i make a 3rd calculated column and tries
This is what i tried `=EXACT([Column1],[Column2])`
I have tried diffrent versions of this with IF and "yes,"no" with no luck.
The formula contains a syntax error or is not supported.
It can not be this hard too display birthdays from a specific month. I can not add webparts either.
Solution is posted below