Annual LEAVE TRACKER With Holidays | Track and Manage Employee Leaves with Ease / Leave Tracker

Подписаться 7 тыс.

Просмотров 55 тыс.

50% 1

Annual LEAVE TRACKER With Holidays | Track and Manage Employee Leaves with Ease / Leave Tracker
In today's video we will see how we can create a Powerful Leave Tracker in Excel that simplifies the entire leave management process. In this video, we'll see step-by-step on how to create an efficient Leave Tracker using Microsoft Excel. In order to allow your employees to plan their vacations beforehand or in advance, you need to keep track of their leaves and vacation balances. Leave or Vacation Tracker is a software or a tool that allows you to keep track of your employees' vacations.
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
📚 Please join the Channel Membership to download the file:
Join the channel from the link below:
/ @office-monk
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
📚 File Link: Only for Channel Members
docs.google.co...
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
#leavetracker #vacationtracker #excel #excelformats #annualleave #annualleavetracker #leavesheet #exceltutorial #exceltips #exceltricks #excelhacks
Topics Covered:
How to make leave tracker
How to make Annual Leave tracker
How to make vacation tracker
How to make vacation tracker in Excel
Excel Leave tracker
Excel Vacation tracker
Automated Leave tracker
Automated Annual Leave Tracker
Automatic Leave Tracker
Simple Leave tracker
Easy Leave tracker
Please Like, Share & Subscribe; #OfficeMonk

Опубликовано:

16 сен 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 178

@ranjitachaudhuri45 23 дня назад

ITS VERY HELPFUL.YOUHAVE PRESENTED APPREHENSIVELY.THANK YOU

@Office-Monk 23 дня назад

Thank you so much for loving the video and getting connected with the Channel 😊

@cflanagan2279 11 месяцев назад

Vijay IS AMAZING! At excel and apparently at life. There are not many people who would take the time to help a stranger. I wish I could do more to say thank you than just writing here on his page!

@Office-Monk 11 месяцев назад

Thanks a lot for your kind words. It really means a lot 😊

@michaelhartman5485 8 месяцев назад

Wow...Using this video (mostly) and another RU-vid video, I was able create an Attendance Tracker that will most likely impress the powers that be where I work...Thank You VERY MUCH

@Office-Monk 8 месяцев назад

Fantastic. Seems you are an Excel lover. Keep creating awesome and innovative formats. 😊😊😊

@moinsaeed7866 3 месяца назад

Thank you for sharing your hard work with all of us. Looking to see more of these videos. Loved it!!

@Office-Monk 3 месяца назад

Thank you so much for loving the video and getting connected with the Channel 😊

@logeswaran9425 28 дней назад

Excelent - Crystal Clear

@Office-Monk 27 дней назад

Thank you so much 😊😊😊 Please stay connected for such interesting formats and videos

@SahilShaikh-lk5yu 10 месяцев назад

Thank you so much for this, keep sharing superb work like this!

@Office-Monk 10 месяцев назад

Thank you so much 😊. Please stay connected for such interesting topics and formats

@dsbohra 10 месяцев назад

Very good explanation, well done.

@Office-Monk 10 месяцев назад

Thank you so much 😊

@AbdulRashidAbubakar-d7k 8 месяцев назад

This GREAT! Thanks

@Office-Monk 8 месяцев назад

Thanks a lot for loving the video. Stay connected for such amazing formats

@yogis5411 Год назад

Good 👌

@Office-Monk Год назад

Thank you 😊

@tusharthukra 7 месяцев назад

Hi, kudos to the efforts taken by you. Its so easy to understand and follow. I have two issues to understand. One is, after putting formula for date and days it shows #value for february month. However all other months are showing up correctly. I checked format but that also is fine. Second, half day are also showing up as 1 leave, however i want them to be recorded as 0.5. Can you please help.

@Office-Monk 7 месяцев назад

Thanks for loving the video and getting connected with the channel. Now coming to your issues. Please check the Spelling of February, by mistake you must have entered Febuary. Now coming to second point, Please divide half days by 2 and it will count all half days as 0.5 Hope this works

@nishchithanayak2297 3 месяца назад

Super ❤

@Office-Monk 3 месяца назад

Thank you so much 😊

@SaifAlMamun-j1h 2 месяца назад

Thank you, I am create a annual leave tracker using your method. but some formula don't work, I will be grateful if you sent me Annual Leave Tracking excel sheet. Thank you

@Office-Monk 2 месяца назад

Please mail me your format. I will check what's the issue vijaymuukh@gmail.com

@TheAsiff99 8 месяцев назад

Hi, Thank you for the video, I am training myself to do this in google sheet, however on conditional formatting 14:44 for =Countif(Holidays,H$4), it is saying invalid formula. Is it the same for google sheet and excel file? Thank you for the video great job and easy to follow

@Office-Monk 8 месяцев назад

Give me your mail id. I will send the file

@user-lf5gw6kb4u 6 месяцев назад

Thanks for the great video, I’ve learn a lot from your videos. I am also having the same problem with holidays, on my excel sheet shows #NA ? End it up, I deleted the whole sheet too frustrating. How can I solve the holiday problem? Should I do data validation of Holidays and dates together or only dates ? Thank you

@Office-Monk 6 месяцев назад

In case you find #N/A error, it means, There's no holiday on that specific date. Please put the criteria of =iferror( ),"") just before VLOOKUP and your issue will be resolved. No need of Data Validation for Holidays. This formula is working and I am 100% confident about this without any shadow of Doubt.

@itsplaytime9976 Год назад

Thank you. Very helpful. New subs here.. only thing i can't figure out is why Feb doesnt show the days in a month.. but the rest are okay😢

@Office-Monk Год назад

Thank you so much for loving the video and getting connected with the Channel. If comfortable please mail me the format. I will cross check the issue with Feb month. vijaymuukh@gmail.com

@saurabhmore2312 5 месяцев назад

Thank you so much... This is really awesome and very well explained tutorial. ❤❤❤❤ How do we update if we have 2nd and 4th sat off ?

@Office-Monk 5 месяцев назад

Thank you so much Saurabh. The only option is, Put 2nd and 4th Saturday in your Holidays list and it will feature automatically in your Format

@Rinze007 Год назад

First off, a big shoutout for this super helpful explanation! I've checked out a bunch of others, but this one really hits the spot. But, here's a little something I've been thinking about. I work with temporary staff quite often, and it would be super cool if we could automate the removal of employees from the schedule once their employment end date has passed. For instance, if someone's last day is in March, it'd be awesome if they automatically vanished from the schedule starting April. This would save me some manual work and ensure the schedule stays accurate without me having to tweak it. Any chance this auto-removal feature could be on the cards for future updates? It'd be a game-changer for folks like me who juggle schedules and temporary staff all the time. Thanks again for this fantastic resource!

@Office-Monk Год назад

Thanks a lot for the Compliment. You really scared me with such a big comment. Hahahahahaha. Names can't be vanished but Yes it can be highlighted.

@jstevenbj Год назад

God Tier Video

@Office-Monk Год назад

Thank you but I didn't understand what you want to say 😊😊😊

@jstevenbj Год назад

@@Office-Monk HI, I Just found your video extremely usefull and wanted to say thanks ! Could you try a variant of this same table but with a simpler style ? Maybe this can be a series for people Who are looking for simple concepts. Again, great work!

@Office-Monk Год назад

Thanks a lot for loving the video and getting connected with the Channel. These are link of 2 Videos on Leave Tracker. Formats are different and I am Sure, you are going to love them ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-bLQ4_EH8V-o.html ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-UkL7lt6OSsM.html

@asishkarmakar974 7 дней назад

In this for highlight holidays you are using the formula in conditional formatting=COUNTIF(Holidays, cell value) and then choosing the colour. Cell value means first date of the month. Here I can't understand. Please help

@Office-Monk 7 дней назад

Ashish, Why are you confused ? I haven't used any Countif in the conditional formatting. Can you please tell me at which minute in the Video you saw this formula ? Please send me your contact number

@asishkarmakar974 7 дней назад

@@Office-Monkthe minute is 14:47 .... You use COUNTIF for highlight the holidays

@Office-Monk 7 дней назад

Over there I have used Countif because in the Settings Sheet, I have given Holidays a name through Name Manager. In recent formats I stopped using Countif

@asishkarmakar974 7 дней назад

Now what should we do?

@asishkarmakar974 7 дней назад

Instead it what we must use? Please send me the formula. Thank you for your guidance.

@asishkarmakar974 6 дней назад

Is it possible to create this annual leave tracker for 10/20/50 as desirable? Also want get the continuation of previous leave record.

@Office-Monk 6 дней назад

Yes. I have created Annual Leave tracker in a single sheet. You will get the video on my Channel

@davidchibiya963 4 месяца назад

I enjoyed the video thank so much for sharing your work. The problem is that when I changed the year to 2024, the holidays are not showing. Can you help me with this?

@Office-Monk 4 месяца назад

Hey David, Thanks for loving the video and getting connected with the Channel. Coming to your concern regarding Holidays, Go to Settings Sheet and update Holidays list. Current Holidays list is of 2024. You will have to add the Holidays of 2025 or Coming years over there and only it will feature in the format. In case you want to keep the list of 2024, just add the Holidays of 2025 under that. And in case you don't want Holidays list of 2024, just overwrite with the Holidays list of 2025. Hope it helps

@andreaparavey6650 3 месяца назад

Thank you, very usefull. I have a question, how can you add a new employee once the table is all finished.Tthank you

@Office-Monk 3 месяца назад

Once the table is finished, add new employees in the setting sheet and drag down the monthly format. Each and every data will be updated automatically

@fanymelo7424 Год назад

Incredibly helpful! Thank you.

@Office-Monk Год назад

Thank you so much 😊. Please stay connected for such interesting topics and formats

@amarobinho Год назад

What an incredible video! But I was wondering what would happen if we deleted all of those buttons (that 12 months) after we finished the leave tracker?

@Office-Monk Год назад

Thank you so much for loving the video. When we click on button of specific month, we directly jump to that month. In case we delete the buttons, we will have to click on sheets name to reach to the specific months. There will be no impact on the format. 😊

@amarobinho Год назад

Thank you so much for the help. I truly appreciate it. @@Office-Monk

@learningexcel7 11 месяцев назад

Hi, love your video thank you for such detailed explanation! Just a quick question - how do I ensure holidays for future years update too? I've managed to make cells fill in using formula Holidays23, Holidays24 etc but how do I make titles update too? Also, how do I ensure each month gets refreshed and 'L' do not stay as you move to the next month? Thank you so much for this!!!

@Office-Monk 11 месяцев назад

For future update of Holidays, you will have to update your Holidays List. Titles of Holidays can be updated through VLOOKUP. Each months can be refreshed through Macros

@vikaskaushik1667 8 месяцев назад

How we can calculate the leaves at designation wise as well in this

@Office-Monk 8 месяцев назад

You can put multiple countif in a single cell to count leaves, designation wise

@LalaAsgarova-ub2ds 4 месяца назад

thank you for your excelent video! Just i would like to ask about function DATEVALUe, this function give me error -VALUE, may be could explain me please?

@Office-Monk 4 месяца назад

=Datevalue("1"&month&year)

@ravleenkaur1799 4 месяца назад

Nice Sheet, but only issue in my sheet is that when I put attendance in january, that's also shows for february as well. I need this to be changed for other months.

@Office-Monk 4 месяца назад

For 12 months, you will have to create 12 Sheets in advance. Or you can use Macros to get the data deleted when you change the month

@J_Bant 2 месяца назад

Great tutorials but I have one question. how can do filtering if for example I only needed the record for a particular person or 2

@Office-Monk 2 месяца назад

Thanks a lot for loving the video and getting connected with the Channel 😊 Regarding your issue / challenges, Use VLOOKUP or XLOOKUP TO extract the data of a Particular person/ employee. Increase number of rows if you want the specific data of Multiple employees

@J_Bant 2 месяца назад

@@Office-Monk thanks for the response, but can you make a demonstration out of it I'm not really proficient in the commands and language of excel, also to note I'm also having a trouble regarding the Annual summary when I'm doing the =COUNTA(January!AM6+February!AM6+ etc. etc... it turns out to be a value of 1 and doesn't total them all. appreciate your response

@Office-Monk 2 месяца назад

@reconnaissance7396 vijaymuukh@gmail.com Please mail me your excel sheet. Let me check the issue

@J_Bant 2 месяца назад

@@Office-Monk bro I have tried it myself it seems that I have added COUNTA in the annual summary, I have deleted that command and everything went perfectly well thanks for the support, but I saw your new video, regarding the leave tracker last 2 weeks ago. I appreciate you well.

@Office-Monk 2 месяца назад

There are many Attendance Sheet and Leave Tracker formats on my channel and all are different. Whenever someone asks for specific thing in the format or some idea pops up in my mind, to make the formats better than before, I create a new video

@TheronShade Месяц назад

can you do the date 2:55 without Saturday and sunday ? no working days on those

@Office-Monk Месяц назад

Will try in next format

@TheronShade Месяц назад

@@Office-Monk can't wait, thanks 🙏

@josephamoako4963 Год назад

Your videos are really helpful.. A I'm finding it difficult to memorize all the formulas could you help me please 🙏

@Excelpaaji 23 дня назад

which software do you use for recording and editing videos

@Office-Monk 23 дня назад

Hey Excelpaaji, I use inbuilt software of MacBook for screen recording and imovie for editing videos. Sometimes I use inshot too for Video Editing

@cflanagan2279 11 месяцев назад

So helpful! Thank you! Ive gone over and over mine but cant figure out why only the holidays in January are showing up. If I add another January holiday to the master list on the settings tab, it shows up in all the months :( Any advice?

@Office-Monk 11 месяцев назад

If comfortable, please mail me your format. I will review, do changes and will send you back. vijaymuukh@gmail.com

@cflanagan2279 11 месяцев назад

Thank you! Its sent. I did change a few things to make it work better for our company. Lol hope you dont mind :)@@Office-Monk

@Office-Monk 11 месяцев назад

@@cflanagan2279 I would love to see your format 😊

@lm8584 5 месяцев назад

Hello. Is there a way to pull the same leave for an employee across multiple days without having to use the drop down and enter info for each day individually? Thanks!

@Office-Monk 5 месяцев назад

Don't use Data Validation to create Dropdown and thn you can do the entries manually

@reshaniliyanage7962 27 дней назад

All went well. but vlookup formula doesn't work for holidays.... Can u help me

@Office-Monk 27 дней назад

vijaymuukh@gmail.com Mail me your format. I will check

@TK-ke7qq 3 месяца назад

Hi, thanks for this video, i have created everything on here but whenever i put the leave type in a month same replicates on other months, how do i correct that? I just want a tracker that shows the month and details for that month..Is there a formula?

@Office-Monk 3 месяца назад

In the very beginning, you will have to create 12 sheets for 12 months

@TK-ke7qq 3 месяца назад

@@Office-Monk Thanks for your prompt response. Are you saying i have to restart? How does the formula work for other sheets Or do you have a video for that

@Office-Monk 3 месяца назад

vijaymuukh@gmail.com Please mail me your format. Let me see what issues it has

@lalitaarumuegam5396 5 месяцев назад

Thanks for guidance..I have a question. Using this tracker how to deduct total ANnual leave so they can see their balance Annual leave..

@Office-Monk 5 месяцев назад

You can insert additional column for Target Leaves and can deduct it from Total Leaves in the Annual Sheet to show Leave Balance

@lalitaarumuegam5396 5 месяцев назад

@@Office-Monk what is the formula? Can you do video for it

@lblanton1034 Год назад

This is the first video, I was able to follow, and do all of the formulas without messing them up. However, I did wonder if there was a way to have the leave put in the "numbered days" boxes as .25 or .50, how could I go about calculating the leave? I would just put in S on the day someone missed for being sick but it doesn't tell me how many hours that person took.

@Office-Monk Год назад

Thank you so much for loving the video and getting connected with Channel. More than happy for you that you were able to incorporate all the functions and formulas without any error. I noted your concerns and will surely try to come-up with some concrete solution. I have got many more formats on my Channel which you are surely going to love. Stay connected 😊😊😊

@lblanton1034 Год назад

Yes Please do, I am currently tracking 160 employees on paper in a "leavebook" and I can no longer function with this setup, TOO much paper. In the meantime I am watching your other videos@@Office-Monk

@Office-Monk Год назад

In case you download the formats, it can be done from the link provided in the description box

@lblanton1034 Год назад

So I actually requested access to the link, but ended up building my own chart as you built yours in the video. You did give me access to the chart though. Is there a special format I can put in so when ever i put "1.5S" into a date for the employee and it will transfer the number to the right side of the column in the leave column bit?@@Office-Monk

@Office-Monk Год назад

@lblanton1034 I think it can be done by inserting the Criteria of "if", just try once using "Nested if", it will solve your problem for sure. In case you are not able to do it, please let me know.

@ravishankar-sg9ry Год назад

Bahot badhiya sir automatic attendance sheet upload kare sir plzz

@Office-Monk Год назад

ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-2kIIdJfGeEc.html Recently ye video load kiya tha Attendance Ka

@martamatos2626 9 месяцев назад

Was it possible to place all months in one sheet? One below the other? And how can I keep up with changes in staff? If it links to the employes list... And I put an entry date I want them to show after that date and if they leave the oposite? I would really apreciate the help 🥰

@Office-Monk 9 месяцев назад

You can do the changes in format as you want. I have created 12 sheets just for analysis to be simple. If you want 12 months in a single sheet, you can do easily. You can put Employee List manually instead of connecting it through formulas.

@martamatos2626 9 месяцев назад

@@Office-Monk 😔 I wanted the list to read the employees considering their date joining the team and with 2 blank rows in between and cannot find how 😭

@Office-Monk 9 месяцев назад

vijaymuukh@gmail.com If comfortable, please mail me your format. Also mention the points in detail which you want to change. Let me see what I can do for you

@gurpreetsinghsehmi2696 2 месяца назад

Hi there, I am getting error in the sheet, the pto is getting highlighted in the cell when i am changing the months , its reflecting in other months as well. Can you please hlep me with the error what mistake did i make

@Office-Monk 2 месяца назад

vijaymuukh@gmail.com Mail me the format

@ayusyazlin1902 11 месяцев назад

i have follow your video but why when i put leaves which is SL or PL on January then the rest follow the same in another month?

@Office-Monk 11 месяцев назад

We will have to create 12 sheets for 12 months and 1 sheet for Consolited or Summary. Seems you watched the video till mid only 🤔

@ayusyazlin1902 11 месяцев назад

can i ask? the total of sp,pl and others is 1 right for one day... how can i add on 0.5 means it for half day ya? @@Office-Monk

@Office-Monk 10 месяцев назад

Divide total by 2, in the formula

@angelmartins2621 7 месяцев назад

Which excel version are you using? Mine does not have the classic tab on Conditional format

@Office-Monk 7 месяцев назад

I am using Office 365 in MacBook. Excel of MacBook and Windows is little different. It hardly matters if your Conditional Formatting has Classic or not. Just go to "Use a formula to determine which cells to format" and put the formula

@angelmartins2621 7 месяцев назад

It worked. Thank you

@Office-Monk 7 месяцев назад

My pleasure. Please stay connected with the Channel for such interesting topics and formats

@srisril2889 24 дня назад

Dear Sir, I have a Question, i have preapred along with you seeing this youtube. When i enter the leaves, PL, WO in my excel for my employees, it is not showing any updates. Please suggest where my mistake will be, how to correct it. Waiting for your help. Thanking You in advance.

@Office-Monk 24 дня назад

vijaymuukh@gmail.com Please mail me your format. I will check and will let you know what's the issue

@srisril2889 22 дня назад

Sir, I have sent in mail to yourself.

@Office-Monk 22 дня назад

I am not able to download the file. Please send a new mail and also mention all the issues you are facing in the format

@ReddiNaidu-x7u 11 месяцев назад

in this video, if I am not wrong, the formula COUNTA(AN6:AW6) @ time 17:29, is Sum formula

@Office-Monk 11 месяцев назад

Thanks for highlighting. It should be Sum function

@Lanesra1 5 месяцев назад

Hi. Do you mind sharing the file with me? My cells doesnt automatically colour the weekend cells like yours did. Please help. Thanks in advance

@Office-Monk 5 месяцев назад

Drop me a mail on vijaymuukh@gmail.com Will send the file

@shaminahabib7648 10 месяцев назад

Hi, I am having problem using datevalue function. I've tried converting the format still unable to do so. I followed as what you showed in the video still it came out as #VALUE

@Office-Monk 10 месяцев назад

If comfortable, please mail me your file. Let me check what's missing vijaymuukh@gmail.com

@deniswales 6 месяцев назад

Hi, I was able to create the template but the month of October is not working for all the years just that month instead of having dates and days of the week there are just ###. What could be the problem?

@Office-Monk 6 месяцев назад

Increase cell size

@Office-Monk 6 месяцев назад

Please let me know if it worked

@manikandandhanaraj8360 8 месяцев назад

Am not able to see the month buttons, it's just showing as image and hyperlink also not showing, when converting into google sheets, can u plz help on this. Because this type of sheets should be shared with team which is easy to share via google sheets

@muskanjuneja4891 8 месяцев назад

The leaves are not changing with the month. What to do?

@Office-Monk 8 месяцев назад

There are 12 sheets for 12 months. You will have to create 12 blank sheets in advance

@KennethThomas-d7k 6 месяцев назад

Will this work in Google Sheets?

@Office-Monk 6 месяцев назад

Couple of things might not work in Google Sheets. Soon I will come up with Leave Tracker in Google Sheets

@rohullahtasang1703 10 месяцев назад

Sir when i created pivot table and select them from feb to annual when i am pressing delete it show me that we cant this perform task on pivot table

@Office-Monk 10 месяцев назад

Please ensure you haven't insered any shape in in format

@paulinewairimu8407 9 месяцев назад

Hello sir, thank you for the video. I also have the same problem. Please assist

@Office-Monk 9 месяцев назад

In case any shape will be inserted, pivot data can't be deleted in one go. Ensure there is no shape and thn delete the data

@prithvipatel2845 8 месяцев назад

Why is the total using CountA shown as 10 - per all employs??

@Office-Monk 8 месяцев назад

Hi Prithvi, Please use Sum for total, instead of Count.

@leau4745 Год назад

How to record if employee take only half a day leave?

@Office-Monk Год назад

In that case you will need Check in and Check out Time Tracker. Please watch my most recent video of Attendance Sheet, with check in and check out time

@HRArchtech-fb8hk Год назад

Hello, How to connect attendance sheet with leave tracker

@Office-Monk Год назад

Instead of Connecting 2 Sheets it's better to mark Present, Absent and all the leaves in a single sheet. In the end where leaves are getting counted, insert two extra columns. One for Present and the other for Absent and you are good to go with the Format

@HRArchtech-fb8hk Год назад

@@Office-Monk i am creating a dash board it includes attendance sheet,setting sheet,employee manager,leave tracker,salary slip, payroll..all things in 1..so can you help me with that

@Office-Monk Год назад

@HRArchtech-fb8hk create Pivot Tables for each sheet and thn create your Dashboard. The work will be easier thn you expected. Providing link of a video for better understanding ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-AhFBDLujsWM.html

@HRArchtech-fb8hk Год назад

@@Office-Monk I am using gsheet all thing I have created in gsheet only

@Office-Monk Год назад

@@HRArchtech-fb8hk I mostly work in Excel

@baidehi.kashyap 5 месяцев назад

Can you please share me the file .

@Office-Monk 5 месяцев назад

docs.google.com/spreadsheets/d/1lTvSr_IHXLqi2RCpVG0xPVyxVPv8FaiG/edit?usp=sharing&ouid=109065873300131166242&rtpof=true&sd=true

@ahmadaltaf221 4 месяца назад

Please send excel copy of this

@Office-Monk 4 месяца назад

Link is in description box. You can download it from there

@mags7545 10 месяцев назад

Hello, is there a way that you can help me to create 1 for my staff, I am clueless when it comes to excel

@Office-Monk 10 месяцев назад

You can mail me on vijaymuukh@gmail.com

@Indianlucknawi 12 дней назад

CountA in total leaves is giving error to me

@Office-Monk 12 дней назад

Please put Sum

@Indianlucknawi 12 дней назад

@@Office-Monk Thank you for quick response however I am getting error for both countA and sum .. error is there are more circular references where a formula refers to its own cell either directly or indirectly

@Office-Monk 12 дней назад

@Indianlucknawi vijaymuukh@gmail.com Mail me the format. I will check

@Indianlucknawi 12 дней назад

@@Office-Monk It got resolved.. thank you so much ... I have one more question.. please in holiday I have calendar for 3 different region where some holidays are common eg. New year and for some dates are common but different holiday how include in the list

@Office-Monk 12 дней назад

@Indianlucknawi New year, 2nd holiday, 3rd Holiday You can do this. The other way is to create filtered list as per region. When you will change the region, all the holidays will change

@NeelGangradeofficial 8 месяцев назад

The file is deleted, can you please re-upload the file? thank you

@Office-Monk 8 месяцев назад

docs.google.com/spreadsheets/d/1io0OGG_ARIzRbb3rns2Meim7VhrHEJoH/edit?usp=sharing&ouid=109065873300131166242&rtpof=true&sd=true

@siddharthmohini8696 Месяц назад

can you send me this sheet

@Office-Monk Месяц назад

Hi Siddharth, File download or edit access is only for Channel Members. Please join the Channel Membership and I will share the Excel file. You will get the link in description box to join the Channel Membership