Watch the first part here...kzitem.info/news/bejne/maiDraCmmF-Fapg
@xlpedia
5 күн бұрын
Part 3 >> kzitem.info/news/bejne/yKaarH6mcqGgd20
@peacefulmusic9456
Жыл бұрын
Hello. Can you please show how can we handle multiple days leave requests. Eg if there is leave start and leave end date with 3 consicutive leaves. How can we query that in calendar
@xlpedia
Жыл бұрын
Sorry, you will probably need to repeat that 3 times.
@xlpedia
4 күн бұрын
I just came across to this comment an realized I should've suggested you to use leave count (1,2,3,...etc) instead of leave type (PL, CL,...etc) to solve your problem.
@travelnatureentertainer2785
8 күн бұрын
After completing this sheet, where will we get over all leave details of individual
@xlpedia
8 күн бұрын
@travelnatureentertainer2785 If you are asking for a monthly or yearly summary, you'll need to create a separate worksheet for that. Don't worry, I'll create a video on this regard. You'll get the link from me later on this thread.
@xlpedia
7 күн бұрын
@travelnatureentertainer2785 For now, you can check out the spreadsheet linked in the description. It's updated with monthly & yearly sheets.
@xlpedia
5 күн бұрын
@travelnatureentertainer2785 Here it is! kzitem.info/news/bejne/yKaarH6mcqGgd20
@nyoleyeemonms7478
Ай бұрын
How to add Year pls explain
@xlpedia
Ай бұрын
You'll find it in part 1 of this video linked in the description.
@nyoleyeemonms7478
Ай бұрын
@@xlpedia Your video is great. What I want to know is, can you teach me how to make both Month and Year? please 🙏🙏🙏
@xlpedia
Ай бұрын
@nyoleyeemonms7478 I'm not sure what you really want. It'd be better if you'd explained a little bit in detail or with examples.
@maricrisbinamira8924
4 күн бұрын
How to add 31?
@xlpedia
4 күн бұрын
I'm struggling to figure out what do you mean by that. Anyway, the tutorial, at times, only shows the days up to 28 due to the screen zoom in. But, later on, you can see that it is in fact up to day 31.
@maricrisbinamira8924
3 күн бұрын
When I tried it, the days in each month, it has 1 to 30 only. Some months have 31, when I tried to drag the days, the 31 won’t reflect.
@xlpedia
3 күн бұрын
00:10 You can see, the days are extended to 31. However, if you have already selected a month (let's say April) from the dropdown that has up to 30 days only, the cell for the 31st day will be shown as empty due to the formula even if you drag it to the 31st cell. Change the month to (let's say) January to see the 31st day. You can also check out the template workbook linked in the description to be 100% sure. Hope it helps.
Пікірлер: 17