In a small double-blind study, Johns Hopkins researchers report that a substantial majority of people suffering cancer-related anxiety or depression found considerable relief for up to six months from a single large dose of psilocybin — the active compound in hallucinogenic "magic mushrooms."
Official evidence-based answer: The little research we have suggests that psilocybin can decrease anxiety (and depression) not just in people with life-threatening illnesses, but in anyone. This meta-analysis is a good place to start.
Anecdotal evidence answer: We have case studies and observational reports from clients that indicate anxiety gets reduced and stays reduced for at least a few weeks.
Personal experience: Yes, it reduced anxiety, especially social anxiety for me.
There is plenty of great info on the web, and I'm really looking forward to this book coming out "Psilocybin Therapy: Understanding How to Use Nature’s Psychedelics for Mental Health" in April of 2024. If you want something available now, "Psychedelics For Everyone: A Beginner’s Guide to these Powerful Medicines for Anxiety, Depression, Addiction, PTSD, and Expanding Consciousness" is a good option.
Please note that all of this research is on macrodosing, not microdosing.