Here is what I am trying to do. We get 6.67 hours a month vacation. I want a cell that will calculate 6.67 x the month. So that it will automatically change on the 1st of each month. Is there a way to do this.

Thanks