Tracker to track employee time off, birthdays and work anniversaries

Excelgirl

New Member
Joined
Oct 15, 2022
Messages
3
Office Version
  1. 365
Hi Excel World,
I am presently trying to make an interactive employee tracker to track employee time off, birthdays, and work aniversaries. I am not a fan of using the all 30 days for each month across a spread sheet. I put in drop down lists for employees names, type of day off, etc. I want to put in a vlookup or something at the bottom to lookup all the days off for one employee. I would also like to track when I have received each employees time sheet so I know who has not submitted them yet.

I love excel and have done some of the medium to advanced things in the past but I have only done them once here and there as needed. I am not an expert. I am interested in what other excel users might be using or any helpful tips. I realize this might be a step by srep project that may take me awhile. Any help or advice would be greatly appreciated.
 

Excel Facts

Remove leading & trailing spaces
Save as CSV to remove all leading and trailing spaces. It is faster than using TRIM().
Hi,
welcome to forum

For ideas always worth a look for what is already out there.

here is one free example: Employee Leave Tracker Template
you can look at that may be something that you can adapt to develop your project further.

Dave
 
Upvote 0
Hi Dave,

Thanks for welcoming me. I am glad to be here!
Thanks also for the very quick response and the example but it is not what i am looking for. We already use something similar to this. I want to upgrade it in a huge way. As I stated early I do not want to use a 30 day version spreadsheet. I want to create something that is interactive, with search, results, lookups and maybe pivottables. That is the kind of thing I am trying to build.
 
Upvote 0
Ideas can be adapted to specific need but no worries if not what you are looking for.
best to share where you have got to with Forum using MrExcel Addin :XL2BB - Excel Range to BBCode and outline assistance needed to progress your project.

Plenty here to offer assistance

Dave
 
Upvote 0

Forum statistics

Threads
1,213,543
Messages
6,114,240
Members
448,555
Latest member
RobertJones1986

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top