how to set excel to track attendance and vacation hours available

I've created an attendance sheet and want to place the letter "a" on days
employees are absent...How do I get the sheet to count the number of "a's" in
a calander year? Also, Vacation time is accrued at a rate of 3.3 hrs per
month...is there a way I can have it automatically add in those hrs?

Hello vrhodes,

It would help to know more about how you have the Worksheet laid out. Like, which cells will have the "A" and which cell will have the hours. Is there only one sheet for the entire year with all the employees listed on it or are the employees on separate sheets?

Sincerely,
Leith Ross