Forum Discussion
I need month
eg. January - vacation - 5
February- vacation - 6
March - vacation - 7
I need like that how to change
- 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.
16 Replies
- For example
You have 01/22/2020 in cell A1. To extract the month, in cell B1, execute the formula: Text(A1, "mmmm").
When you hit the Enter key, you have January in cell B1.
I hope that's what you're trying to do - There is not start date!
Regarding the end date we can figure it out from the start data and the duration - 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.- This my spreadsheet
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.
- I send attach file. i need like that
- I'm sorry, but I'm still not understanding what it is you need. I'm sure it's clear in your mind, but it's not clear to me. And is it possible to upload the actual spreadsheet (taking out any real names)....an image file is not as helpful.
But please describe in more words, or with an example, what it is you're NOT able to do that you want to do.
