Forum Discussion

RHannah_'s avatar
RHannah_
Copper Contributor
Jan 13, 2022

Calendar for Employees' Vacations tracking

Hey, my idea is to have an excel file that is made of 2 Sheets: sheet1: is a template of a year calendar overview with an employee name field sheet 2: is the List of Employees in the company (arou...
excel
Formulas and Functions
RHannah_'s avatar
RHannah_
Copper Contributor
Jan 13, 2022
Hello NikolinoDE
thanks so much for the files you've sent 🙂
I am going on with this little project i am doing here,
i will keep on searching untill i find the answer 😄 and will definitally write you about it .
wish you a nice day and stay safe
Rhannah_
  • RHannah_'s avatar
    RHannah_
    Copper Contributor
    Jan 17, 2022

    Hello NikolinoDE 

     

    Hope my message finds you well 🙂
    i haven't found out the way to link the two sheets i told you about earlier.
    but i found this template in excel. it is almost what i want..

    https://templates.office.com/en-us/employee-attendance-record-tm02780235

    in the main sheet (Calendar Overview), the vacation days are reflected as colors., and i wanted them to be reflected as a Letter. 
    So I will add a row under each month and in this row - under the vacation date - i want to have a letter instead of a color
    for Example (V) for Vacation instead of having the day colored with blue, the V letter should apper under the date when i add a vacation date in the sheet (Employees-Attendance-Tracker) ..
    may you please help ?

    thanks a lot in advance 

    Ranah