Results 1 to 6 of 6

Guidance with employee shift schedule

Threaded View

amir705 Guidance with employee shift... 02-05-2021, 12:39 PM
JeteMc Re: Guidance with employee... 02-10-2021, 12:19 PM
amir705 Re: Guidance with employee... 02-10-2021, 03:53 PM
JeteMc Re: Guidance with employee... 02-15-2021, 07:34 PM
amir705 Re: Guidance with employee... 02-17-2021, 05:45 PM
JeteMc Re: Guidance with employee... 02-18-2021, 11:07 AM
  1. #2
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 365 version 2501
    Posts
    18,885

    Re: Guidance with employee shift schedule

    *The input sheet requires some 'cleaning':
    - The shifts are only on 'Sundays', 'Mondays' and 'Wednesdays'.
    - It would be simpler if it would automatically remove the unnecessary days, or simply auto-create a monthly table with the 3 days only
    Cell A1 is populated using data validation that references the list of months in column AL
    Cell A2 is populated using: =INDEX(AM2:AM13,MATCH(A1,AL2:AL13,0)) and is custom formatted yyyy
    Cells B1:AC1 are populated using: =IF(WORKDAY.INTL($A2,COLUMNS($A1:A1)-1,"0101110")>EOMONTH($A2,0),"",WORKDAY.INTL($A2,COLUMNS($A1:A1)-1,"0101110")) and are custom formatted ddd, d
    Cells B2:AC2 are populated using : =B1 and are custom formatted d
    Let us know if you have any questions.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Day and Shift wise allocation from Roster / employee shift schedule
    By Ravi_Kadu in forum Excel Programming / VBA / Macros
    Replies: 22
    Last Post: 01-11-2021, 07:40 PM
  2. Noob here- best approach to extract personal schedule based on an employee schedule sheet,
    By fortnight_skyrim in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 04-15-2018, 01:02 AM
  3. Employee Shift Schedule
    By ShermyG in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-21-2018, 10:19 AM
  4. Building an Employee Shift Schedule that Automatically Deducts Breaks
    By derdoktor in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-11-2016, 04:09 AM
  5. Add employee name to schedule based on Shift and date
    By BARBIEE in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 04-18-2016, 12:44 AM
  6. Replies: 0
    Last Post: 10-27-2014, 11:54 PM
  7. Shift Schedule - 3 Shift Coverage - Auto Populate Roll-up Summary Schedule
    By chips1256 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 08-31-2012, 09:32 AM

Tags for this Thread

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