Resetting data to zero when a specific date is reached

Hi all,

I've attached an Excel doc that helps my manage vacation time for my employees. I've got tow issues with it. I've outlined the issues in the document itself. Essentially, I need to reset a column after a certain date has been reached and to ensure that a specific column takes into consideration two different vacation period.

Thanks