I need help to set up a spreadsheet

  • Thread starter vacation spreadsheet
  • Start date
V

vacation spreadsheet

I am doing a spreadsheet for vacations. I will start with hours earned minus
hours used. Each pay period I need to add more hours earned to the last hours
earned. Is there a way to do this without having to calculate each individual
when the new hours earned is the same amount per employee?
 
B

Bob Phillips

You could put all the paydates across the top as column heading and the
people in rows, and then plug in the extra vacation they will earn for each
month. You can then get the earned to date with a simple

=SUMIF($1:$1,"<="&TODAY(),2:2))

which gives you the earned to date for the guy in row 2.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top