monday

Hi all, I'm trying to search through a column of A's, B's and null return values for the next instance of A or B, can anyone help? The formula I'm working with is currently working with dates to find the date of the next monday in a week A or B (school 2 week timetable), when I get to school...

I have a team of 6 people i would like to do the following to show how many employees i have working between 6am - 6pm. Here is a sample of data i have employee 1 Monday 8:00am - 4:00pm Tuesday 8:00am - 4:00pm so on. employee 2 Monday 9:00am - 6:00pm Tuesday 9:00am - 3:00pm so...

Hello, I am looking to create a formula to update a rolling inventory need. please see below - thanks for the help! Need formula for E/F/G BELOW: <tbody> A B C D e f g 1 Current Inventory Monday sale Tuesday Sale Wednesday Sale Inventory need Monday Inventory need Inventory...

Hello, I am trying to list out the days of each month for every Monday and Friday in a given year. I have cell A1 contain a year, for example 2018. Under the year beginning with B1 will be the months listed out. The row below the months, beginning with C1 should list each day of the month a...

Hello, I have a pivot of info (as below). I have a master copy which i save every week by week number and dump in data from an external source. I want to filter "Time Into Loading" and "Time Finished Loading" so that it filters out and blank cells, however when new data is entered into the...

Hi I'm trying to list the dates that represent the begining of each week of the year but, when a week has two months, I would like to split it. I do not want to use vba to do that, just a single formula. The bold+underline cell in the table below is the starting date. In the second line and...

Hi all, Based on a warranty date, I would like to Set a Date and Time Date should be at least 2 days before the warranty expiration date. If warranty date is a Monday, date should be at least Wednesday from previous week @ 10 am or 2 pm Days must only be Monday, Tuesday, Wednesday Time...

I am trying to figure out how to enter a formula into a cell, that will look at a row of cells and select the value in a specific cell. Example: FORUMLA CELL (N) O P Q R S T U =(?) 0 0 0 Monday...

So I may be over thinking this, but I need a formula that will take any column with the header MONDAY and sum rows 4-6. <tbody> A B C D 1 MONDAY MONDAY TUESDAY TUESDAY 2 AM PM AM PM 3 A 50 250 200 100 4 B 100 100 250 50 5 C 50 100 50 200 6 D 200 200 50 250 7 E 200...

I am trying to prepare a list of Monday's which excludes any holidays lists but I can't seem to get it to work. I tried the WORKDAY function but then it skips the Monday and returns the Tuesday. Example Cell C4 is the previous Monday 10/02/17 And holidays are listed in cells J5:J30 which...

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 =...

Hello, I have been looking through different posts but I am still not able to find quite the solution. Basically my problem is that I need to obtain the week number of the year and the number of day of the week from a column that I have with dates in the following format: 1/29/2018 7:08:17 AM...

I have a workbook where I create a new sheet daily, Monday through Friday and it is named for the current date in ddmmm format. I run a macro to format the sheet like I want it. I also need to pull some data from the prior day's worksheet. Can anyone tell me how to refer to the sheet name for...

Hi, I’m building a dashboard and have last weeks numbers (5 days of data) and I need to compare it to this weeks based on the day of the week we are in. Example, 500 tickets last week This week is Wed, so based on average we would have 300 tickets up to Wed. I need a formula that looks at...

Here is a sample of my data, "Monday" will appear more than once in Column B but there will only be one Monday with "3" in Column A... How would I return the "01:05:03" to G2 please? Excel...

I have a spreadsheet (duh!) that uses dates for nominations of natgas. On Monday, I nom for Wednesday (highlighted), on Tuesday, I nom for Thursday (highlighted), etc. The problem comes when today's date is a Thursday, I want the conditional formatting to highlight Saturday, Sunday, AND Monday...

Hi i'm trying to get a week to date(WTD). This is date -1 The problem is EXCEL starts the week on Sunday and I need it starting Monday. So I've built a helper cell to my table that subtracts a day. IE January 1/18 = December 31/17. Everything works fine see formula below. Excel for the start...

I have a vertical list consisting of every single day in the year and a corresponding price. I'm looking to use AVERAGEIFS() to average only the Monday values in a given month excluding any holidays, the dates for which I have listed elsewhere for reference. Right now I'm trying to use...

I have the following code to delete a row if the value in column C is Monday. My question is, if there is no Monday value will there be an issue, so far I have run the code and I do not see any problems. Is there an alternative. Thank You Code Sub DeleteMonday() Dim lr As Long...

Hi, The hour range is between store open times (Monday - Friday 09:00 till 17:00) If an order is placed we have a time of 6 hours to ship out the order. Example: An order is recieved Monday at 09:53, it has to be completed by 16:00 09:53 rounds up to 10:00 + 6 hours Though if an order is...