+ Reply to Thread
Results 1 to 3 of 3

Trying to get my roster into excel and create a function

  1. 11-15-2022, 01:40 AM #1
    TobeornotToby
    TobeornotToby is offline
    Registered User
    Join Date
    11-15-2022
    Location
    Australia
    MS-Off Ver
    Microsoft Office 365
    Posts
    1

    Trying to get my roster into excel and create a function

    Hello Everyone.

    So just for some context, I'm in a 24/7 position and I want to custom create my roster, so i can see ahead of time when I have days off.
    The thing is, its not the usual 5 days a week.

    It goes as follows:
    4 days on - 5 days off
    5 days on - 4 days off
    5 days on - 5 days off

    And I have no idea how to create a function that can utilise this across a calender. Not sure where to look. If anyone can guide me to a youtube tutorial etc etc. That would be amazing.
    Thank you! :D

    (If it helps, I have minor knowledge in excel. I've created a few reports before that also used power Bi. But i'm no pro.)
    Reply With QuoteRegister To Reply
  2. 11-15-2022, 03:14 AM #2
    AliGW
    AliGW is online now
    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. 2405 (Windows 11 23H2 64-bit)
    Posts
    81,461

    Re: Trying to get my roster into excel and create a function

    Welcome to the forum.

    There are instructions at the top of the page explaining how to attach your sample workbook. Screenshots are of little practical use as we cannot manipulate them.

    A good sample workbook has just 10-20 rows of representative data that has been desensitised. It also has expected results mocked up, worked examples where required, relevant cells highlighted and a few explanatory notes.
    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 With QuoteRegister To Reply
  3. 11-15-2022, 06:25 AM #3
    tanasedn
    tanasedn is offline
    Valued Forum Contributor
    Join Date
    06-23-2021
    Location
    Romania
    MS-Off Ver
    2021, 365 v 2208
    Posts
    722

    Re: Trying to get my roster into excel and create a function

    Assuming that you have dates in Column E starting from E2,
    In F2 insert a formula:
    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    Attached Files Attached Files
    Last edited by tanasedn; 11-15-2022 at 06:41 AM.
    Diana Tanase

    If the solutions offered helped you to solve your problem, then mark the thread as SOLVED (thread tools in the top menu) and you can click on * to add reputation to those who helped you, as a way to say thank you !
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. How do I create and extract data from a rolling / continuous work roster using excel?
    By Brendan1908 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-10-2017, 10:54 AM
  2. Use excel forum to create roster/staff schedule
    By Throughstream in forum Excel General
    Replies: 1
    Last Post: 02-27-2017, 09:05 PM
  3. Using checkboxes to create a roster
    By BrownBoy in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-04-2014, 08:03 PM
  4. How to create a staff roster....how far can I go
    By Rogeo in forum Excel General
    Replies: 6
    Last Post: 01-11-2014, 04:36 PM
  5. Create roster
    By greywolf1987 in forum Excel General
    Replies: 4
    Last Post: 05-03-2012, 06:12 AM
  6. How to create simple formula in Excel for shift roster
    By Mahaveer in forum Excel General
    Replies: 2
    Last Post: 10-29-2010, 01:39 PM
  7. Create Roster
    By techi in forum Excel General
    Replies: 0
    Last Post: 01-20-2009, 03:10 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1