I did some more fiddling and got a little closer. Everything works for the next vacation year (2018-2019), but not if it is the current vacation year (2017-2018). The month accrual seems to not like something. Check out the attached files and see what you think.
Note: I did a bit of iferror wrapping just to blank out some #VALUE cells on my actual worksheet.
Bookmarks