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
NikolinoDE's avatar
NikolinoDE
Platinum Contributor
Jan 13, 2022

RHannah_ 

I can imagine what you mean, but in order to be able to offer you an exact solution, as I have written to you, some preconditions would be necessary.

Everything is possible in the world of Excel ... and you can do just as much wrong if you don't know how-where-what-when in advance. Welcome to your Excel discussion space!

Many things can be solved in Excel, with many possible paths, which is why very precise specifications are required.

 

However, here are two possible approaches that might help.

COUNTIF function

COUNTIFS function

Or

VLOOKUP function

LOOKUP function

XLOOKUP function

 

Two files are attached with examples (I'm not sure you can download them).

 

Hope I was able to help you with this info.

Thank you for your understanding and patience

 

NikolinoDE

I know I don't know anything (Socrates)

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