Here is an example of the spreadsheet. Maybe it will help explain what I'm looking for better:


Start Date # of Days Earned Per Month Balance Type of Time
9/21/1987 2 9.75 Vacation 1 80 Sick


So in this example, the employee earns 2 vacation days on the 21st of every month. I need a forumula which will add 2 vacation days to the balance column on the 21st of every month.

Since I'm trying to bring my department into the computer world, this is just a template, if you think a formula could easily be created from another set-up, I'd be willing to make adjustments.

Thanks again for everyone's help!

--
Message posted via http://www.officekb.com