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.
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.
Christina--I am very sorry, but I still need to understand what it is you're looking for. The spreadsheet is a VERY SOPHISTICATED spreadsheet, taking advantage of some very advanced formulas. So it mystifies me why you're even asking for help, in the first place--surely there's somebody there at your place of work who does understand this workbook and how it's to operate.
That aside, I see a formula that isn't working, under the column heading Days (Column F), but I'm not sure what it's supposed to do...is that formula the problem? Where the formula itself reads: =NETWORKDAYS([@Month],[@[Total month of leave ]],lstHolidays)+[@Adjustment]
and the result is #VALUE!Please provide a better description of what you actually need here. Where does it go? What should it read? Where is it that you're supposed to put in start date and end date?
