+ Reply to Thread
Results 1 to 2 of 2

Work Rotation planner

  1. #1
    Registered User
    Join Date
    12-12-2015
    Location
    China
    MS-Off Ver
    2013
    Posts
    1

    Work Rotation planner

    Hi, I have googled for quite sometime and I could not find the answer. I need excel to caculate for me a planner where when one person takes leave on certain date, the next person will fill in the gap. And also each person must have a fair amount of days in a month. For example,

    10 staffs
    5 days work
    Each person must have 2 or 3 or 4 days of duty per month on a rotational basic.

    So whenever I plot in the leave plans of the staffs, excel could fill in the blanks on the days they are not on leave(s), and each person has a fair and equal days of duty per month.

    Been googling but I'm not sure if excel can perform this task?

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

    Re: Work Rotation planner

    Probably, but without a sample workbook showing exactly what you need, it's hard to say for sure.
    Ali


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

    Forum Rules (updated August 2023): please read them here.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Work Schedule Rotation Gantt Chart Help - Conditional Formatting
    By vshen116 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-20-2015, 09:45 AM
  2. Rotation Schedule
    By uniks in forum Excel General
    Replies: 1
    Last Post: 03-16-2014, 08:58 PM
  3. Speed of rotation
    By Stanley91 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-03-2014, 10:22 AM
  4. Work Rotation schedule
    By schaubers in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-05-2013, 01:14 PM
  5. Recipe Menu Planner macro doesn't seem to work!
    By tammack17 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-22-2013, 04:29 PM
  6. Fill planner table relying on data from another table winery planner
    By pleb in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-10-2013, 04:54 AM
  7. shiftwork rotation
    By phuongtran in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-24-2012, 06:25 AM

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