Forum Discussion
I need month
- I'm sorry, but what you are asking is unclear. Are you wanting to show the names of the months only, going down in sequential rows? Only three at a time?
If you could post a sample of the spreadsheet you're working with, it might help. But basically a more complete description of what you're doing, how this fits in the larger picture.
Employee Attendance Tracker template is done to perform day by day tracking. If you go on monthly level (e.g. Employee1 in January was 5 days in vacation and 3 days on sick leave, doesn't matter which days in January), you lost major part of template functionality. Much simpler tool could be used.
However, if go this way, column Days is actually what you called Total Month of leave
=[@[Total month of leave ]]
Since you have only months now without days, you don't have years as well. January is just January, you don't specify of which year. Thus you have actually current year calendar, and on Calendar View dashboard you don't need criteria on years. For example, formula for Sick Leave
=SUMIFS(LeaveTracker[Days],LeaveTracker[Employee Name],valSelEmployee,LeaveTracker[Month],">="&DATE(Calendar_Year,1,1),LeaveTracker[[Total month of leave ]],"<"&DATE(Calendar_Year+1,1,1),LeaveTracker[Type of Leave],'Leave Types'!B4)will be simplified to
=SUMIFS(LeaveTracker[Days],LeaveTracker[Employee Name],valSelEmployee,LeaveTracker[Type of Leave],'Leave Types'!B4)(I did only for sick leaves).
Plus conditional formatting won't work since you excluded days.
That's something like in attached file.
- Ya its correct thank you very much Mr.sergei baklan
Christinath , you are welcome. So, depends on your needs I guess you may find more simple template to show integrated leaves; or use this one with minor modifications for day-to-day tracking.
- Hi Mr.sergei baklan How are you? I need you help. how to add employee number and designation in calendar view Sheet