Excel spreadsheet to track vacation days?

**ladyinblack1964** · 05-23-2015, 02:16 PM

Hello--
I know the answer to my question is pretty simple, but I can't figure out how to do this.
I'm trying to make a spreadsheet that tracks my vacation days, month by month. Every month, I earn so many hours of vacation time, and once a year, I get a personal day I can add in. I would like a spreadsheet that allows me to manually add in my earned hours every month, while keeping a cumulative total, plus allowing me to subtract the hours I actually use.

I know this must be easy, and I've figured out how to do the adding in and subtracting part, but not how to do the cumulative total part.

I have also looked for a template online, but not had any luck.

Can anyone please help? Thank you very much.

**etaf** · 05-23-2015, 02:26 PM

can we see the spreadsheet you have so far ?

and how you have structured the data

**ladyinblack1964** · 05-23-2015, 02:45 PM

I'll have to wait till Tuesday. It's on my computer at work.

Thanks for replying!!

**etaf** · 05-23-2015, 02:59 PM

OK,

Please upload a sample of your workbook to the forum, Make sure you have removed any private information, remember this is a public forum and so available to anyone
Would like to see an example of your data and also a manual mock up of the expected results you want to achieve.

To attach a file to your post,
click "Go advanced" (next to quick post),
scroll down until you see "manage Attachments",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.