A calendar table can help a great deal for such working and also some other calculations. Just type Calendar table on the search SSC and you will see tons of material.
You can extend these tables with financial year columns of your need. It will help you a great deal in your current design and may answer your future queries as well.