Hello All,
I've been searching this forum for many number of years and have always found the help I needed - usually it was because somebody else had the same issue and asked the question and the excel guru's on here answered! So...many thanks for the help that you all have given me (even if you never knew you were helping!)
Anyway, I have an issue that I can't seem to find an answer to. I'm trying to create a "holiday tracker" spreadsheet. Basically what I would like to do is have a dropdown list with the values "earned" and "used". So when I use a holiday, it subtracts from my total and when I earn a holiday (i.e. work on a Saturday) it adds to my total....so it would be something like this;
Date Start Date End Type Used / Earned Days Taken / Earned Balance Weekend Work Earned 10 10 Vacation Used 6 4
So, basically what I'm looking for is what to put in the "balance" column so that if I put a value in the "days taken/earned" column it will add or subtract from my balance based on if I choose "earned" or "used" from my dropdown menu in the "used/earned" column.
Hope that makes some sense!!
Cheers!
Bookmarks