Hello,
I need help building a vacation tracker for my company. i have created a spreadsheet with all the columns i need. now i need the columns to read from each other. if that makes any sense.
Here is the vacation policy
0-2 years of service- accrue .77 weekly
3-4 years of service- accrue 1.54 weekly
5+ years of service- accrue 2.31 weekly
We are allowed 40 hours rollover.
I need the following to reflect:
Column B to read to Column C & D & E- the start will reflect the correct amounts
Column F will be put in by myself
Column F needs to read to column T - (Added in to balance)
Column G-R needs to read to Column S
Column S needs to be subtracted from Column T
Column S needs to have the yearly allotment & rollover amount
I hope that makes sense
Please help!
I have attached the spreadsheet with the columns
Bookmarks