Astrology was known to be false even to Greek philosophers, over 2000 years ago.
There is no solid evidence to support it.
In terms of making predictions, it is no better than random picks (neither better nor worst).
Weather conditions are slightly different as the Moon could have some influence (the tidal effect is not restricted to the oceans - it also affects the atmosphere).
It has been investigated often and, every time, has been rejected.
As for "personal experiences", that is a question for psychology. People remember that one time when a [random] prediction turned out to be true; they forget the other 99 times when it did not turn out. Religion works that way too. "Look! Monica prayed to be cured and she was" (What about the other 99 people who also prayed but still died? We'll just make up a story to say they were sinners, unlike Monica).