I have a spreadsheet where I want to calculate vacation time based on the start date. When the employee have been there a year they get 1 week vacation and it does not roll over. I want to create a formula that resets their vacation every year on their anniversary date. Any replies would be most appreciated! Thanks