1. T

    Attempting to create a rotating work schedule...

    Good afternoon! I am trying to create a rotating work schedule. There are five main colleagues and six jobs. I want to be able to assign these jobs on a daily basis evenly. So every day, someone gets a different job when I click a button perhaps. Is that possible? For the sixth job, I want it...
  2. H

    Calendar Data to Input to Excel like Outlooks built in scheduling form

    Hey There is there a way I can create something similar to the outlook Calendar input form that I can use for budgeting analysis on my excel spreadsheet? Is it crazy hard? Would this need to be done with User forms? Is there an alternate method you would suggest? Thanks in advance! Kind...
  3. D

    Lookup/Match Based on Multiple Details (non-VBA)

    Hey guys, I am trying to set up a spreadsheet to fill in time slots based on day and time information. There are two sheets in the workbook (Calendar and Log) Here is how I have it set up: The name of this sheet is Calendar A B C 1 Wednesday (August 19, 2020) Thursday (August 20...
  4. R

    VBA Comparing Name on schedule to vacation list

    I'm hoping someone on here can help we with what I'm trying to create in our Excel work schedule. In the Sheet "Availability" it lists all of the employee's in Column B. With the date listed in Row 2. In the Sheet "Assignments" is where we enter each employee's assignment for that day (Date is...
  5. F

    Flag shifts conflicts on multi-location schedule

    Hi There, I have been working on a multilocation (6) weekly scheduling board for 19 employees with some of them having different attributes (notary/supervisor). I would like to make sure the same employee doesn't get schedule at two location for the same time, but sometimes, employees have two...
  6. E

    Calculate Days Worked and Days Off

    I’m interested in a few formulas to calculate total number of days worked and days off in a calendar year, and each month based on known values. For example: Employee Day Rate: $500/day If they work a schedule that is 3 days on and 4 days off that repeats itself for a year, I would like to...
  7. M

    variable installment months

    Hi Dears I am not an accountant person that's why i can't calculate this. so please help me i have sheet to calculate the installment amounts of price of the apartment. it's 2500000 $ if cst want to pay 10% (variable percent) in the start which 250000 $ . then install the rest of amount on 1 ...
  8. A

    Generating Sign In Sheets from a Master Schedule

    I'm usuallypretty good about self-learning/teaching myself enough to do what I need to,but today I'm at a standstill. Two reasons why, one, I can't seem to think ofthe best way to approach what I need to do, and second, trying to google thequestion in my head doesn't translate well at all. So...
  9. D

    Month by Number

    Hello, I am wondering if there is a way to calculate months mathematically. For example, if this month is October (10) and I want to go back 3 months to July (7), is there an easy way to show this? Here's what I have: <tbody> A B 1 10 <--using "=MONTH(TODAY())" 2 Oct <--using...
  10. B

    Master Schedule: Conditional Format based on Date

    I have a master schedule file to compile projects from various managers. There are four phases with start/end dates. I'd like to be able to enter the dates for the phases, and have the colors change in the cells to the right of the dates based on the entered dates. Is this a stacked conditional...
  11. C

    Power BI Return Max Date

    I have rummaged through posts but cannot get any formulas to work I have a project table that has Project ID's (only one occurrence of each ID) then I have a schedule table that has the same project id's but multiple occurrences for each task that a project has. Each task has what is called a...
  12. K


    HI ALL, I'm planning to use some formulas to return my employee's schedule which looks clean and more simply from a complicated database. Here are what i have in the original schedule @ sheet_schedule for my 3x employee and a formula to return a concise layout @ sheet_result formula in...
  13. E

    Browser Page Refresh: Reflect new data after scheduled refresh

    Hi, Does any one knows if there is a way to refresh the Chrome view of a power bi report in the service after the schedule refresh? (without using Chrome add ins) [ i have a report that is presented constantly on a tv and refreshes once a hour or so, the view does not update after the...
  14. L

    Use Formulas to Fill Weekly Schedule

    Hi, I have a Weekly Schedule sheet that I would to populate with formulas from the Appointments sheet. Does anyone know how to do this? Thank you Excel WorkbookAIKLMNOPQR1INDEX8:00 AMLunch Start12:00 PMMax working hours per day92Lunch End1:00 PM3Lunch Time1:004INVJOB TIMESTART DATEDAYSTART...
  15. L

    I need new ideas

    I want create new NFL schedule file. anybody have any ideas. Thanks You Thomas
  16. N

    Depreciation schedule in Excel for Straight line method

    Hi, I am trying to create a straight line Depreciation schedule forecast in Excel , based on the asset register received , for the purpose of Forecast , <colgroup><col><col><col><col><col></colgroup><tbody> Asset Current Cost Accumulated Depreciation Net Book Value Date Placed In Service...
  17. T

    Prepaid Schedule

    I am trying to create a prepaid schedule where the beginning and ending dates are mid-month resulting in pro-rated amounts at the beginning and end of the payment schedule. Can someone please help this frazzled person figure the formulas out for my spreadsheet?? I would be most appreciative...
  18. N

    Is this beyond Excel's capabilities?

    Hi all! I have come here several times in the past to find excellent help with my spreadsheets but I am thinking that I may be looking for something beyond the scope of Excel. I have been asked to take over my department scheduling and I am looking for a solution that will replace the current...
  19. J

    Conditional Formatting For an Impact report

    I am trying to make an impact report that will quickly allow a customer to quickly understand the impact of set a weeks work and any delays in their schedule. What i would like to do is make a table with Column A being the project ID, Column B to BA represent a work week, and column BB be the...
  20. R

    Schedule chart help

    Hello! I am trying to create a chart to represent block schedules by date. So far I set up my table and chart as you can see in the image in link ( ). I am stuck with the following: If a date has more than one block (overlapping or not), can you...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back