month_name/day_name warnings followup
xref https://github.com/pandas-dev/pandas/pull/18164#issuecomment-370390747
- [x] passes `git diff upstream/master -u -- "*.py" | flake8 --diff`

Changed the `weekday_name` warning to a `FutureWarning` and catching them in 2 additional tests. 