saturday

I've got my statement wrong or I'm trying to write this incorrectly. I have two drop down lists. M5 has 4 statements - Saturday, Sunday, Monday, Tuesday M6 has 3 conditions - Open, Lunch, Closed I am trying write an IF statement. Saturday & Sunday have the same answer for Open & Lunch =...

Hi All, Could someone help with with the condtional formatting of dates and differnet rules please. If A1 has a date of : Monday - Friday 07:00 - 21:00 and Saturday - Sunday 07:00 - 16:30 = B1 to be coloured AMBER Monday - Friday 21:01 - 06:59 and Saturday - Sunday 16:31 - 06:59 = B1 to be...

If date formula equals Sunday, change to following Tuesday. I have a complex formula where the end user enters a start date in one sell, and then can select lead times in either days or weeks (7 days) that eventually roll up to a final date. The problem is that I can't have any of the...

I am doing a personal budget and wanted I40 and I41 to add together if the 25th of the month fell on a Saturday. <tbody> H I J 40 Car $445 25 41 Groceries/Gas $150 Saturday </tbody> Below you can see on the 25th of the month (Saturday) the $445 took (I27) but not adding in the $150...

Hello, I have a facility where their workweek is Monday through Saturday an I need to be able to determine which day of the month will be the last workday, EOM. I'm currently using this formal for a normal 5-day workweek "=IF(WORKDAY(EOMONTH($L$2,0)+1,-1,holidays)=AJ2,"EOM","")". I did some...

I want to do an index match, with the ARRAY being dependent on what the user selects from my dropdown box in cell B3. Depending on what they select (it will be days of the week, i.e. Saturday, Monday, etc.), I want the named range reference to change (i.e. if they select Saturday, I want it to...

The title really doesn't explain what is going on, I am writing a story and I use Excel for keeping track of the timeline What I am trying to do is show how much time has past between the dates in the same chapter, but I also want to see the dates in chronological order. Some dates get...

So I have this spreadsheet that polled people as to what activities they would like to do. How do I make a pie chart about that shows the percentages of those who said "yes" to each individual thing? <colgroup><col><col><col><col><col><col><col><col><col span="2"><col><col...

Hi, I have a manually entered date in cell B2 (24-Dec-17), I need a formula to fill the next dates from cell C2 onwards, the criteria for dates to be 25th of each month if the 25 is not a Friday or Saturday and also not a holiday, sample shown in the table below. The holidays are listed in a...

I have an Excel column with song titles in it. When I do a Pivot table and sort the data by the songs it keeps putting the song titles "Saturday" and "September" at the top with the numbers instead of down in the "S"s. I am assuming it is treating these as numbers instead of text like September...

Looking to create a file in excel that will help me find a rotating schedule for the following: 1. Saturday and Sunday Work Days 2. 3 Shifts (3 Doctors) on Saturday and 2 Shifts (2 Doctors) Sunday. 3. Doctors cannot work both days. (If you work Saturday you are off Sunday and vice versa) 4...

Column "O" has the Award Date Column "R" has the Bid Amount I am trying to get Column "V" to show the Bid Amount in Column "R" only if the date in Column "O" is withing this week Sunday through Saturday and blank if not within this week...

TABLE 1 <colgroup><col><col><col><col><col><col><col><col></colgroup><tbody> NAME SUNDAY MONDAY TUESDAY WEDNESDAY THURSDAY FRIDAY SATURDAY A ASBURY 1 1 1 1 1 N PATEL 1 1 1 1 1 1 1 TOTAL </tbody> TABLE 2 <colgroup><col width="72" span="8" style="width:54pt">...

Good evening all Trying to sum/combine Column D values. 1. Monday & Tuesday 2.Thursday & Wednesday 3. Friday & Saturday If Column E = TRUE and Column C = 2 for each unique ID. attempted formula =...

Equals Cell Above So here is the dilemma. My last post involved setting a conditional format to set each row that is a Sunday row to be highlighted a specific color. This works great, such that when I copied the 2018 sheet and renamed it to 2019, adjusted the top 2 column A cells which then...

Hi, please help me Formula to sum working hours excluded saturday and sunday to calculate value of cell, employee working overtime hours in 25 days excluded saturday and sunday from previous month 26th to current month 25th. also separate sum for saturday and sunday too thanks

<colgroup><col><col><col span="2"><col></colgroup><tbody> C D E F G Formula use Date2 Weekday Time In Time Out Status 21-Oct-17 Saturday 9:00:00 14:00:00 Present =IF(D3="","",IF(D3="Sunday","Off Day",IF(E3="","Absent",IF(F3="","Absent",IF(D3="Saturday",(IF(F3<TIME(14,0,0),"Early...

Hello all, I was wondering of a simple process to compare schedules to eachother as far as being 100% matched 80%, 60%, etc. For example: A supervisor with Saturday & Sunday off who works Mon-Fri 9:00 AM to 6:00 PM. An agent going to the supervisors team who is Saturday & Sunday off, works...

Hi I have spent SO much time in Excel trying to get this to work but have failed miserably, when I think I'm there, I test it and it fails.... This is the scenario: We pay staff weekly based on 4 different categories of shift as follows (all paid at different hourly rates) which they submit a...

Hey, Not sure how to go about this but I need to populate a cell with the value of 1 - 52 using my work calendar. Currently I'm in week 1 so throughout this week, whenever I open the workbook A1 needs to be "1" and then on Sunday - Saturday if I'm to open the workbook it needs to be "2"...