+ Reply to Thread
Results 1 to 7 of 7

Staff holiday planner

  1. #1
    Registered User
    Join Date
    02-10-2013
    Location
    West midlands, England
    MS-Off Ver
    Excel 2003
    Posts
    2

    Staff holiday planner

    Hi
    I am trying to find a good template to record staff leave all in one place. To keep it simple I like the idea of individual staff sheets the formulate into a front sheet showing a calendar of staff leave in all one place.
    Does anyone have any ideas on how I can make this happen?


    Thanks in advance!!

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    23,435

    Re: Staff holiday planner

    Take a look at my attachment in this thread:

    http://www.excelforum.com/excel-form...e-to-tab2.html

    Hope this helps.

    Pete

  3. #3
    Registered User
    Join Date
    02-11-2013
    Location
    United Kingdom
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: Staff holiday planner

    There is a free holiday planner using Excel here: http://free-holiday-planner-excel.posterous.com/

  4. #4
    Forum Expert Kevin UK's Avatar
    Join Date
    12-07-2010
    Location
    Radstock, Somerset
    MS-Off Ver
    365
    Posts
    1,922

    Re: Staff holiday planner

    Hi Partridge

    Or perhaps a gnatt chart. See the attached file. The dates for holidays in A13:A14 are only as an example and are for the WORKDAY function in cells E3:E5. Your profile indicates that you have Excel 2003, so you will need the ATP installed.
    Attached Files Attached Files
    Regards Kevin


    Merged Cells (They are the work of the devil!!!)

  5. #5
    Registered User
    Join Date
    02-10-2013
    Location
    West midlands, England
    MS-Off Ver
    Excel 2003
    Posts
    2

    Thumbs up Re: Staff holiday planner

    Thank you for the help. All of the options look like they could work well for my situation. I might trial them all to see which on works best for recording the infomation I need.

    Thanks again for all you help!

  6. #6
    Registered User
    Join Date
    08-04-2017
    Location
    Dublin
    MS-Off Ver
    365
    Posts
    1

    Re: Staff holiday planner

    Love excel but for holiday planning its much easier and more compliant and safer for data responsibilities etc. to use HR software. I've used many systems with a mix of design and usability (and they mostly export to excel for reporting ironically!0 but my favourite is link removed. check it out, our staff loved using it too.
    Last edited by AliGW; 08-04-2017 at 09:04 AM.

  7. #7
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, Suffolk (England), but grew up in Sawley, Derbyshire
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2301 (Windows 11 22H2 64-bit)
    Posts
    65,646

    Re: Staff holiday planner

    Be warned: advertising is not permitted here. Post another link like this and you will be banned.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" to anyone who has offered you help in your thread. You can reward them by clicking on * Add Reputation below theur user name on the left, if you wish.


    Forum Rules (updated September 2018): please read them here.
    How to use the Power Query code you've been given: help here. More about the Power suite here.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1