Hi!
I am trying to adjust the excel template for Employee Attendance and have very little excel knowledge.
I need to be able to enter dates other than the current year (2019) so that I can use this for our rolling year record. Right now the date automatically corrects to 2019 on the Employee Leave Tracker sheet and so I cannot see the past years (2018) notations.
It might also help if a formula exists that will delete entries that are more than 360 days old (based on the current date).
I know that allowing for both years might create an error when dates overlap so if the automatic deletion isn't an option I am happy to manually go through when I input data and delete entries older than 360 days. Just hoping there is some way...
Also I would like my "Reprimand" that is listed on the "Occurrence Types" Sheet to be able to hold a whole number but not have that number included in the totals listed in "Occurrences" and "Days w/o Occurrence".
And finally everyone works holidays so I do not want the sheet for "Holidays" at all but am unsure how to remove it from the rest of the sheets code without creating errors.
Thank you for any help you can give!
Bookmarks