I think it's fun sometimes to understand how something works (I draw the line at cars - I just drive them!) and therefore...

Click the images for a larger view.

This is the spreadsheet as seen for a single user. The blue squares representing a day's leave have a value of 1, but you could make the text colour the same as the background so all you see is a square. Equations in the columns to the right add up the number of coloured squares for the month and then deduct it from your allocation.

For a manager to keep track of a team's annual leave it's a case of adding more rows for each month (a different colour for each team member can be good) and ensuring the equations match the relevant line as leave is taken month by month.

**Equations**

*B16: =B5*

Then copy that down to B17:B25, B27:B36 etc. You will only have to enter staff names once now as it will automatically copy down from the first month into all other months.

*AI5: =SUM(C5:AG5)*

Then copy that down to AI6:AI14, AI16:AI25 etc. It adds all the taken leave for the row.

*AJ5: =AK5+AL5-AI5*

Then copy down to AJ6:AJ14 only. It adds the initial leave allocation (AK5) plus any leave brought forward from the previous year (AL5) and then takes off any leave taken during the current month (AI5)

*AJ16: =AJ5-AI16*

Then copy down to AJ17:AJ25, AJ27:AJ36 etc. It ensures that each month's remaining leave is based on the remaining allocation from the end of the preceding month.

**Using the Spreadsheet**

That's it! Fairly simple. Note that the coloured square in C1 has a value of 1 and the coloured and patterned square in C2 has a value of 0.5 to enable half day leave to be calculated.

When you add leave for anyone, copy and paste from either C1 or C2, rather than change the colour of cells to match - as that would not give them a value to be included in the calculations.

The coloured boxes for

*Sick Leave*and

*Allowed Leave of Absence*do not have a value as they would not be counted against annual leave allocations.

Every year you have to create a new blank and move the weekends (grey boxes) to match the dates of the new year.

Have a go! If you're desperate or have trouble getting it right, email me - bispham2[at]hotmail.com and I'll send it as an attachment.

## 241 comments:

1 – 200 of 241 Newer› Newest»A very useful spreadsheet which was just what I was looking for. Thank you very much John.

A textbook example of a leave sheet. After several hours of banging head against desk when i tried to format a sheet to take into account that we would be employing several new members of staff. I found this!!!

And it works in NeoOffice too:))

Ta John

an amazing spreadsheet, well organized, easily managed, and great endeavor.

Keep going on, it’s amazing job what you’re doing. All the best for you John :)

A fantastically organised sheet that is incredibly flexible and just what was needed. Thank you very much John.

Thanks so much John. It's so simple and easy to customize and I didn't have to start from scratch! With only 4 staff this file is exactly what we need to keep track of our annual leave.

Thanks so much John. It's a really simple yet fantastically organised spreadsheet. The file is exactly what I was looking for to keep track of the team leaves.

Hi John,

Many thanks for the Spreadsheet. It will make keeping track of A/L so much easier.

Marc

Hi John

This is excellent and I’ll use it to maintain the leave for Don Adan Coffee Shop, just a small operation but it will allow the owner who is not hugely computer literate to track the leave her end.

Thanks again, much appreciated.

Kate

Sydney, Australia

Dear John - thabnk you for sharing this great spreadsheet! Out of all the tools i found - yours was the only one that perfectly suited my purpose – to coordinate vacation schedules for our team

Everything else was aimed at specific HR department needs, calculations etc

Hi John

Thank you so much for emailing me your spreadsheet....I dont even have to tweak it to start using it...it has saved me hours of time..you are a gem..cheers Lee from Australia

Hi John,Thank you for sending me your spreadsheet so quickly. It is just the sort of thing I was looking for and I'm sure the Team will think it's marvelous. It's a nine hour differnce at the moment between Australia and England, so not quite the middle of the night. Estelle :o)

Hi John, thanks for the super fast response to the request for the spreadsheet. Its exactly what I needed and has saved me a hugh headache with excel date formulae.

All the best

Don

Hi John,

Your spreadsheet was fantastic. Thanks very much.

Many thanks John.

I'm helping a friend running a small panel and this is exactly what we needed.

Cheers,

Kevin

Melbourne, Australia

Thanks a million, John.

The spreadsheet was very user friendly.

I absolutely love it.

Thanks John, this spreadsheet is amazing and certainly very useful for my company. Saved me a lot of work! Kind regards

Thanks John, the annual leave spreadsheet is very useful and just what we need at our company. All the best!

Great post John, much appreciated, Ady

Thanks John, this spreadhseet is amazing and you are very generous to share it with us that need it!

A simple yet intuitive spreadsheet that is easy to maintain! Thanks John, this was just what I was looking for. Kind regards, Mr P.

Thank you kindly John that spreadsheet is fantastic great use of Excel thank you very much

Thanks for the spreadsheet its great, excelent use of Excel thanks alot. Bruno

Just got this now. Looks very good. Thank you

Hi John and thanks for such a quick response.

This is excellent!

Simple to use, visually straightforward and works a treat!

Many thanks

Tracy

Thank you for sending me the Annual Leave spreadsheet. Its meets my needs exactly.

Thanks again.

Hi John

Many thanks for sharing this leave sheet. Your time spent creating this will certainly benefit me and the team I work with

Thanks again

Hi John,

Your spreadsheet is great and can be used universally. I am located in Malaysia and this is exactly what I am looking for. I am also using it for all my staff to plan their annual leave for the whole year. Have also create an individual version.

Thanks for your willingness to share.

Cheers.

Khoo Hai Chew (Malaysia)

This spreadsheet is perfect for seeing at a glance who is taking leave and when and who needs to take leave. There is no mucking about - fabulous!Thank you for providing us with your spreadsheet John and for your quick response.

Hi John,

Thank you so much. Your spreadsheet is simple and easily changed to suit my requirements. With only three staff, you have made it easy for me to monitor annual leave. You are wonderful for sharing... much appreciated.

Hi John

Thanks for sharing this spreadsheet with me. its going to make the annual leave process a lot smoother going forward ......

Thanks again

Stuart

Thanks very much for the spreadsheet. I had devised something similar but was having difficulties with the formulas. Seeing how you've made things work has been a great help.

Your spreadsheet is wonderful thanks for providing it its made such a headache go away!!

Out of curiosity can I ask you how does it work that when you add a name to the first month it gets added to all?

again thanks for great work! and kindness

Juan

For each member of staff the rows for following months each have a formula added so the name cell = the first name cell (ie of the first month). Therefore when you add a name to the first month it is automatically added to all other months.

John

Just amazing - helped me no end

Thank you so much John - you have helped me so much and made the hours of trying that i have done seem so simple. Your fast response has just been amazing.

I 'googled' simple annual leave spreadsheet and found a link to this one. Easily adapted and easy to use - it is everything I needed. Thanks John

Vanessa

Brisbane,Australia

Hi John,

Thank you so much for sharing this useful spreadsheet. It has got everything I need to keep track and maintain the annual leaves of my team members.

It has saved me hours of time to create one. Well, we don't need to re-invent the wheel, rite? :))

Cheers,

Teddy (Singapore)

Many thanks for providing this resource on the internet. A lot fo effort has gone into this and has save a huge amount of time.

Thank you, John, for the copy of the spreadsheet! This will come in very handy for me.

Does what it says on the tin- brilliant

Thanks John

Thanks very much for sending the spreadsheet. Having set it up it is exactly what we need to check our annual leave is spread over the year and much more convenient than the huge old manual holiday boards!

After spending quite a bit of time trying (and failing!) to do this myself I searched online and found this. John very kindly emailed it to me and I'm delighted to say it does EXACTLY what I needed it do perfectly.

Thanks John!

Thank you so much John. Takes all the stress out of excel for this 'excel dummy'. Now I can track leave far more efficiently and at a glance

Thanks so much for providing such an excellent resource to the public. This template was easily adapted to our needs. Very user-friendly and easy to customize. And your speedy response simply made my day. THANKS!!!! :)

Thanks John! Easy to work out leave balances etc. and see everything at a glance. I'll post it up at work and take pleasure in denying my staff their leave applications (kidding, slightly).

Thank you so much. I can now see at a glance whether anyones schedules clashes with anothers. I have just over forty staff on it and it looks beautiful. Thank you again and I look forward to seeing what else you can do to help .

Thanks to all who have commented. Inresponse to Fran from Melbourne, this blog was mainly to be based around project management and e-learning which is my work focus.

However I have created another blog Computer Basics for Free which has a similar function to this post.

The spreadsheet has gone literally around the world and each week brings three new requests for it on average. Slightly more interest than I'd dared to hope!

Dear John, thank you so much for making your Annual Leave Spreadsheet available. I am the manager of a small NGO youth service, I manage 12 staff on 28 hrs per week with no admin support. Be able to access tools like yours for free makes a world of difference to my job. Thank you again.

Thank you John for the excellent spreadsheet. It's very easy to use and add to and creates a very clear table for others to read. We are a small charity so being able to use your ready-made sheet saved us lots of time and resources.

very nice spreadsheet, I would like to download it, is there a download link here ??

thank you

Hello John

I got the spreadsheet, thank you very much, very nice of you to share it around for free, I am going to use it at my work for tracking annual leave and sickies for approx. 40 ppl. I am planning to do some minor changes i.e. translating it into croatian language and including some additional conditional formatting, thanks again ...

zvonko, (makarska, croatia)

Thanks so much John! This spreadsheet is amazing and exactly what I was looking for. It is very organized and has all little details that I needed.

Thanks again!

Dear John:

Thank you again for the spreadsheet. It will be very useful a I manage leave schedules of the office. Much appreciated.

Dear John, thanks for this, really helpful. Sean

would it be possible to get a copy of your amazing spreadsheet please?

Yes, by emailing me at the address given at the end of the blog post.

Hi John. I would really love a copy of your annual leave spreadsheet but I'm struggling to get hold of your contact details. The link to your website appears to be broken, but maybe I'm just being really thick. Can you help please?

Robert.

At the foot of this blog post it gives my email address - j.burke[at]northumbria.ac.uk

Thanks for the heads up about the broken link though - that web site has gone as it was provided by my previous ISP.

John

Hi John,

An easy to use Annual Leave spreadsheet.It has all the features I require. Brilliant!

Best wishes

Michael

Lovely little spreadsheet - nice and simple to use and maintain. Thanks John.

Thanks John!

Fantastic spreadsheet! so simple to use!

great system!

Lee

The simplicity of the spreadsheet is what makes it so great. This takes all the hard work out of monitoring staff leave.

Many thanks John.

John, Just what I was looking for. Fantastic leave sheet.

Much appreciated.

Many thanks..

That's great, thanks, John. My office will be astounded when I blind them with technology! I've now created one for 2010 and you could publish it on the web if you wanted.

Dear John,

Thank You so much for sending me your spreadsheet. It is brilliant. You saved me a lot of time - and now after inspection of the formulars I understend, after all... So I am not as stupid as I thought ;o)

Thank You very much indeed !!!

Thanks again John, excellent spreadsheet - quick and easy to use. Much appreciated

John

Thank you so much for the spreadsheet you sent me, it will help me a great deal.

All the best.

:o)

Thank you SO much for emailing me this spreadsheet. It's hugely appreciated as I am the first (and only so far!) employee at my new place of work, so we are still finding our feet and this will be no end of assistance.

Thanks once again.

S

This is brilliant John,

Thank you so much... saved me a load of time and work.

I have to monitor the annual leave of 25 sales reps and this will be a big help, fantastic work!!!

Thanks this is just what was needed. Thanks very much

Great, thanks very much for the spreadsheet John, got it running already and very helpfull it is.

Thanks

Tom

Great work, John. Much appreciated you response to my request. Thank you very much.

Thanks, the best!

This is the kind of spreadsheet that I was looking for. Its really great!. Will be implementing it begining Jan 2010.

Many Thanks for sending it to me.

Rushdhi.

Thanks very much for the spreadsheet John. Very very cool

Thanks John, your spreadsheet has helped me immensely...I manage 11 staff and have been manually recording their annual leave to date... which has proved not only time consuming but from the correct data your spreadsheet has now shown me I have been awarding more days than actually due!

thanks again, Fen

This spreadsheet is very helpful. I have been pondering the best way to set something like this up and found that John already had. Thanks for sharing and saving me a lot of time!

Thanks so much John. Fantastic, intuitive spreadsheet. Really kind of you to share.

Best Wishes,

Eve

John- thanks so much for sending me this attachment so quickly. Fantastic, intuitive spreadsheet design. Really kind of you to share.

All the best

Eve

Thanks John, the spreadsheet saved me a lot of work.

A very user friendly tool to track leave and staff performance. Well I actually find it useful in even tracking my staffs discipline at work....absenteeism, overtime,punctuality. Great work John!!)

John, you are a star! Thank you so much for this. It also helps me learn a bit more about the workings of formulas in Excel.

Monica

Dear John, just to say thanks a million for this great tool. I found it to be quite ingenious, with clear demacations on full day leave or half day leave,lie day, etc.

Quite useful and it has just skyrocketed my career as a Human Resources Officer for a small firm.. I cant thank you enough. And to think it also comes with a user manual that is just too handy. It provides continuous education for users on how to manipulate data on an exel spreadsheet.

Well done John and May success be yours on your Education Project.

Carol, Nairobi, Kenya.

Thank you so much for your generosity in sharing your work, and also for your speedy reply!

Just what our organisation neededboofla.

Thanks again,

Kathryn.

this is what i've been looking for...

thank you so much for responding immediately to my request..u're awesome John..:)

cheers,

Diane

Absolutely brilliant makes my life so much easier and works straight out the box. thanks so much john

It's so rare that someone makes something so useful available for free! Your spreadsheet seems to have been a great help to many people. Count me among them. Thanks, John.

Thank You John for sharing such a good thing. I love the holiday remaining function and how intuitive it is to use.

Thanks John for sharing this. It is so easy to use, it's complicated to do for a lot of people but you made it easy for everyone. All the best!!!

Awesome! 3 years after posting John is still helping people (ie-me) and taking the time to reply to emails.

Finding free stuff is easy; finding USEFUL free stuff isn't. Thanks John!

Very very helpful - much appreciated - solved a lot of problems. Thanks very much :-)

John the cibernetic angel, thanks a lot for sharing this with us!!!

I wish you all the best.

I've used this spreadsheet for a long time at my previous workplace and couldn't wait to start using it in my new office!

Thanks for sending it John!

John

Thank you for your prompt response to my request, the spreadsheet is wonderful, very user freindly.

Thank you and much appreciated.

Keep up the good work

Steven

Port Moresby

Papua New Guinea

I requested this from John and whilst waiting gave it a go and created it myself ! Thanks a million for a simple but effective spreadsheet that will save no end of time. Regards Steve

Thankyou so much for the speedy reply! Just what I was looking for and will save me from lots of hours sitting at the computer!

All the best,

Vicky.

Thanks John. Apart from being incredibly useful, this spreadsheet has really helped my understanding of Excel. The gift that keeps on giving.

Thank you John for a quick response and a simple yet effective spreadsheed.

It seems a rare thing nowadays that a complete stranger would do something to make life easier and not try to sell it. Thank you again.

Marius

South Africa

Hi John,

Thanks a lot for your prompt response and help. This excel is very helpful and make our life easy.

It's very generous of you to share this.

Hi John

Thanks for prompt supply of the spreadsheet - I have added a few extra coloured squares to cover other types of absence to track such as flexi leave - but this was easy as you've done all the hard work already. The spreadsheet not only looks visually pleasing but is simple to use.

Many thanks for sharing it

Best wishes

Lee

Hi John,

Thank you so much for the spreadsheet. Starting up an Autism early intervention centre with minimum funding has been quite stressful. But having this easy to use spreadsheet is already making life easier for us IT/Admin novices.

Barbara/Australia

Thanks for sending this to me so quickly John - I work in education too and hope that it does what it says on the can. I'm going to have a quick play with it now, many thanks again,

Claire

OMG This is the best thing sinced sliced bread!!!!!

Fantastic John - thank you so much for making this available.

Winging my way through a new job - used this as one of my tasks - bosses are most impressed - THANKS!

I owe you a beer or two!

Michelle :-)

Hi John!

This is the absolute BEST A/L spreadsheet I have seen! Thank you so much for sharing it with me. I truly appreciate it!

I'll be watching this space to see what you come up with next...

Best From Dubai

Heather

Hi John

Thanks so much for sending the spreadsheet through. Just what I've been looking for. Thanks for sharing!

Dear John,

I am proud to write on your web page.

Thank you for e-mailing me the "Annual Leave Spreadsheet" you saved my time, you are a life saver.

Thank God we have such a craetive person like you. Excellent Job.

Kind Regards

Rasha Oct. 2010

Hi John,

I just wanted to thank you for sending me a copy of the spread sheet. Being in Australia, I actually received your email late last night. I'm happy to say, that after staying up most of the night playing with the spread sheet, that I reluctantly dragged myself off to bed at 2am!

You have done such an amazing job. Thank you for being so kind as to share this with others.

I really appreciate this.

Thanks so much.

Karen

Karen

A very useful spreadsheet John. Thanks very much. I did follow the instructions and work it out myself which I was able to easily. I just didn't have the creativity to create it in the first place so having a template made it much easier.

Nicki, Hull

thanks a million for sending on a very useful spreadsheet, very clever, thanks again,

JH

John,

Thank you very much! I have made changes to cover the idiosyncrasies of my particular setup and it works perfectly. It has made life so much easier!

Thanks again

Paul

Thank you so much for this very useful spreadsheet John. It will save us hours of work.

Christine

Hi John

Is it possible to obtain a copy of your spreadsheet? I have looked at the formula's you discuss in your blog to try ane create the sheet myself but I cannot fathom how you are counting the "coloured cells".

We also wish to track long service leave acruals so I will need to add to your sheet accordingly.

Email me please. Though the coloured cells also hold the value 1

What a fantastic tool you have created John! Thank you so much for making it available, it has made life SO mcuh easier!

Keep up the great work and Thank You!

Hi John

Thanks for a great spreadsheet. Very helpful and logical.

Regards,

Guy

p.s. did you know there is a famous radio dj in South Africa called John Burkes

There are, perhaps sadly, a great many John Burkes in the world. There used to be 9 in the Blackpool phone book alone many years ago - I've conquered the urge to keep up to date with that now! :-)

Presidents of cycling clubs, musicians all over the place, and possibly my favourite John Burke I've never met has a sea lion act in a German circus. We are legion...

For anyone who remembers a story in the Blackpool news several years ago; I am

the one who got thumped by his mistress's husband after being found in bed and unable to run away because he'd taken his wooden leg off...notThanks very much, this would have taken me days to create... you are a champ

Many thanks for the spreadsheet John, simple to use yet sufficiently thoruough to capture all the details needed.

Very responsive on the e-mail as well!

Thanks,

Dan

Hi John

thanks so much for the spreadsheet - it has saved me so much time and hassle - really appreciate the quick response too.

emma

So quick response on email.

Template very usefull.

Thx a lot.

It's just the spreadsheet for the job - thanks John!

I had been looking for an excel sheet for long to track leave for my staff and your sheet was the best solution to what i needed, many thanks John

brgds surjeet

The spreadsheet is awesome, easy to use and a time saver. Thank you for allowing us to use this spreadsheet.

Carolyn.

Thank you so much John, you are a lifesaver! ;)

Great Work!Can i get the copy.

Many thanks

You can get a copy by emailing me at the address shown in the left hand column of the blog.

John

Thank you so much for sending me the annual leave spread sheet,it is perfect for us. It would have taken so much time to develop our own.....Thank you John.

Thanks John. An easy to use spreadsheet that I have our whole office using now!

This looks ideal. Could you email me a copy please. Thank you very much.

Jory

You need to email me at the address shown in the left hand column. That way I will get your email address so I can send it. :-)

A useful template, easily adapted if required as there are no macros or unusual functions. Adapted it for my own use and running it with Libre Office (Open Office).

Thanks for the Spreadsheet John! you have saved us so much time with keeping track of everynes annual leave, very much appreciated!

Jasmine, Australia

Hi John

Thanks for the brilliant spreadsheet - really appreciate you sendin it on and has been a great help already in assigning Annual Leave. Many Thanks

Hi John, many thanks for giving me a template (a bit too hard to start from scratch for my knowledge!).

Simple system, efficient works fine for me. We are 6 staff and the entire year can be printed on 2 A4 sheets.

All the best. Chris

Thanks John for sending a copy of your Annual Leave template. It works a treat!

John

I can't thank you enough for taking time out to send me your annual leave spreadsheet and the speed with which you replied. It is so clear and easy to use. Only wish I'd come across it sooner!

Brenda

Thank you so much for taking time in sending me the useful spreadsheet. I greatly appreciate the assistance you have provided me.

Well done, John.

Hi John,

Than you so much for the help with this spreadsheet. Such a life saver!. Works a charm and and its very easy to use.

Thanks

Dan

Thank you for this fantastic, easy to use spreadsheet. I emailed for some help and within no time you emailed me the spreadsheet. You have helped me enormously. You rolled what I had in three seperate sheets into one.

Thanks for the spreadsheet.

You made my life easier and the spreadsheet is easy to use.

Thank you John. The spreadsheet helps me a lot in my work.

Thanks John. This is a really useful spreadsheet, and easy to use.

Much obliged.

Simple and easy to use. Exactly what we needed for our small office. Thank you!

aedrompsThanks so much John. Just what I was looking for. Simple and clear. Much appreciated. Emma

This Annual Leave spreadsheet is amazing.

we have customised it slightly to manage the leave in hours instead of days which wasn't that diffcult to do.

very useful spreadsheet indeed!

thanks John! :D

This spreadsheet is a life saver!! I tried in vain on my own to get the formulas to work correctly. Unfortunatly, my excel skills were failing on me, so John took pity on me and forwarded his version and now I am rocking out leave tracking at my office!

Thanks JOHN!!!!

Ah yes - this is the right attitude! Don't just monitor leave - rock out that tracking!!! :-)

Thanks John! I have been trying to figure out how to create this type of sheet and was struggling.You saved me ☺

Thanks very much for the template, John. This will save me lots of time and headaches in tracking people's annual leave....

A great little spreadsheet! Just what we needed to track leave in our SME. We adapted slightly to also note Overtime Worked, but adding a cell with -1 or -0.5 for full or half days. Really good and well worth downloading. Thanks John!

Thanks alot John, really appreciate your quick response and that is exaclty what i was looking for.

Thanks for this John, can't believe how hard it was to find one that was useful. It's great. Thanks also for mailing me as an attachment.

Thank you so much, very simple to use it helped me out so much.

Great work

Awesome spreadsheet, does exactly what we need and very easy to use.

Thanks for sending this through John, good job!

Thank you so much for giving me the spreadsheet to work with. Very generous of you indeed. Has same me loads of time and brain power! Many thanks, Austin

Thanks John. What a great, easily customisable spreadsheet you have created. You've certainly made my work life much easier!

Please help. I would love to try out your spreadsheet for a new job I have started as Administrator.

Thanks

EHeath

@EHeath You need to email me - the address is in the article or in the left hand column. Otherwise I won't know where to send it.

John

Thank you so much John for sending me the spreadsheet so quickly! It is so simple and saved me a lot of time trying to get one done.

With gratitude from Singapore,

Jacintha

Thank you so much John its fantastic and has given me a few browny points in the office

Jacki

Hi John

Thank you very much for sending me the spreadsheet so quickly which is much appreciated. The spreadsheet is so easy to use and does exactly what I needed it for. Great piece of work that is beneficial to a lot of people and all the best. Thank you once again... B Iqbal :-)

~*Thank you SO much!*~ The spreadsheet is exactly what I need to help me in the office. Simply brilliant! Thank you , thank you! Jennifer

Thanks John,Exactly what I've been looking for and will make my life a lot easier.Really appreciated.

Thanks John, excellent spreadsheet and very helpful. Denise

Thank you so much John, this is going to make my planning so much easier.

How do i organise it to be able to print a separate sheet for each employee detailing their annual leave plan individualy.

@CL You could simply select the rows for other members of staff then do a [right-click] and "hide".

Print out for the member of staff then select a range of rows above and below the hidden rows and then [right-click] and "unhide" to bring them back.

Alternatively if you were going to print them on a regular basis, create a separate sheet for each person. Take my sheet and keep the top row for each month but delete the rest of the rows in each month. Then re-save the sheet for each member of staff.

John

Thanks so much John, Really appreciate your help. The spreadsheet is a great help to me :-)

Thanks for sharing your knowledge with everyone.

Lisa

Hi John,

I have been looking for something like this, would you please email me a copy at sawan_202@yahoo.com

Thanks

Sawan

A clean, simple and well thought-out solution to a matter that can be a real 'time-eater'. Easily expandable and very user-friendly.

Have spotted the request from sawan_202 but ploease note, instructions for contacting me are given both in the post and in the blog's side panel. Please email me for a copy of the spreadsheet.

I read every comment (obviously, as I have to approve them!) but even with the best will in the world, I do read my email a little more regularly!

John

Thanks a lot John, much appreciated for your quick response

regards

Sawan

love the spreadsheet - extremely useful and exactly what i was looking for and thanks for the quick response!

Hi John

Superb, this really does "exactly what it sais on the tin"

Many thanks for the quick response and for creating something so simple and easy to use.

I run a small construction company with 5 employees and keeping track of days off, sick days etc. had become a nightmare, i trawled the web but only found dodgy sites or expensive sign up to stuff.

This really does keep it simple and from someone who comes across so genuine.

All the best John, your a star

Thanks John For the swift delivery, this is exactly what i need, and so easy to use.

The spreadsheet already become a valuable tool for me to manage my team's annual leave.

The best thing about this spreadsheet is that John has followed a very sound methodology.

K.I.S.S

I chanced upon this spreadsheet through a Google search, and have found it be the most simple and functional Annual Leave template around. John shows that it doesn't have to be an insurmountable task. Thank you Mr. Burke!

You're very welcome - I normally only get called "Mr Burke" when I'm in trouble with the wife... :-)

Thanks so much for this - it's really comprehensive(and has saved me a looot of time!)

Cheers!

Julie

This is fantastic. The spreadsheet is exactly what I was looking for and does a great job tracking annual leave for all our staff.

Many thanks for the incredibly speedy response and giving up your time to help so many people with their excel woes.

Go John!

Thanks John, for being so generous with your spreadsheet and for responding so quickly to my email. I am extremely grateful - you have saved me an enormous amount of time!

An act of kindness - very grateful and will be most helpful

Absolutley perfect for what I need and such a quick response. Can't thank you enough!

The spreadsheet is fantastic-clear, easy to use and does exactly what I want it too!! When you look at other ones on the web that you have to pay for it shows how good it really is!! Thanks John

Thank you very much for emailing me your spreadsheet, you saved me from big problems...

Extraordinary work! Simply brilliant.

Cheers,

Mandy

Thank you so much for your kindness, time and the speediness in replying. So much appreciated.

Thank you for the quick response in sending the spreadsheet. It is really amazing that there is still someone out-there who would share his hard work for free! I am really thankful and wish you all the best!

John, thank you very much indeed for the spreadsheet - it is really useful, very well done to you for producing such a great project! And a HUGE thank you for sharing it with us!

Best wishes,

Natalya.

is it possible to have a copy of it?

Thanks very much.

Hi John

Thanks very much for the spreadsheet. Easy to use and understand...it's exactly what I've been looking for.

@FunnyNappy instructions for contacting me are given both in the post and in the blog's side panel. Please email me for a copy of the spreadsheet.

It provides good overview and application. Its simple to use and very useful. Thanks a lot

Dear John

I think your spreadsheet is amazing and user-friendly. Thank you so much for sharing the spreadsheet with me and others, very kind of you.

Great stuff, and fairly easy to amend for a April to April business year too!

Thanks John. Simple to use and make changes to - I need leave without pay as a separate type, and may add study leave too.

Have added 2013 for planning purposes too. Very easy to update.

Thanks John

Top Spreadsheet very useful and great for me to track everyones leave !!

Top Man.

this is a well organized spreadsheet just nice for a small office, very easy to read.

Thanks John!

Excellent work!!Simple to use and very organized!

Thank you

This has saved me a lot of time and effort. As simple to use (and modify if required) tool. Brilliant. Thanks John.

Pestide

This sheet is incredibly organized, and so easy to customize. This saved me so much time and was excatly the type of spreadsheet I was looking for. Thank you so much for your generosity in sharing!!

All the best!!

Thank you so much for your generosity in sharing this brilliant spreadsheet! It was exactly what I was looking for: easy to use, organized and customizable.

All the best to you John : )

Post a Comment