monday

  1. D

    Search column for next of a given value?

    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...
  2. K

    Team weekly time calendar

    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...
  3. E

    What Formula to use for Rolling Inventory?

    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...
  4. T

    listing Every Monday and Friday's Day of the month

    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...
  5. S

    Filter on Blanks not working

    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...
  6. S

    List of week's first day but split when one week reach the end of a month

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

    How to get a date formula based on several criteria

    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...
  8. D

    Selecting a value in a row of cells that is greater than zero

    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...
  9. J

    Add certain rows based on column header

    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...
  10. D

    List of Monday's excluding Holidays

    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...
  11. B

    Sumifs Multiple

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

    Work Week and Weekdays starts at different time

    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...
  13. P

    Refer to sheet in VBA that is named for yesterday's date

    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...
  14. P

    How many days ago was Monday - this week

    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...
  15. How_Do_I

    Formula Help

    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...
  16. zakasnak

    conditional formatting questions

    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...
  17. S

    Formula challenge, with week to date

    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...
  18. P

    Formula to average all Monday values in a calendar month excluding a holiday

    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...
  19. B

    If No Value

    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...
  20. J

    Tricky Maths formula > Calculate Due time

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

Some videos you may like

This Week's Hot Topics

  • Finding issue in If elseif else with For each Loop
    Finding issue in If elseif else with For each Loop I have tried this below code but i'm getting in Y column filled with W005. Colud you please...
  • MsgBox Error
    Hi Guys, I have the below error show up when i try and run my macro in File1 but works fine if i copy and paste the same code into file2. [ATTACH...
  • CELL FORMAT - IF CONDITION
    My Cell Format is [B]""0.00" Cr". [/B]But in the cell, it is showing 123.00 for editing. (123 is entry figure). (Data imported from other...
  • Show numbers nearly the same
    Is this possible. I have a number that can change very time eg 0.00001234 Then I have a lot of numbers 0.0000001, 0.0000002, 0.00000004...
  • Please i need your help to create formula
    I need a formula in cell B8 to do this >>if b1=1 then multiply ( cell b8) by 10% ,if b1=2 multiply by 20%,if=3 multiply by 30%. Thank you in...
  • Got error while adding column and filter
    Got error while adding column and filter In column Z has some like "Success" and "Error". I want to add column in AA if the Z cell value is...
Top