thursday

  1. E

    Next Availble Date from Given Date

    Hi, I am trying to calculate the next available delivery date , either Tuesday or Thursday based on the date given in Q10 first but N10 if there is a date entered The delivery slots would be only weekday Tuesday or Thursday, excluding the weekends many thanks for any help
  2. R

    Conditional Formatting based on VLOOKUP

    I need help conditionally formatting cells based upon the text found in a VLOOKUP - I am creating a calendar that references background data to automatically populate events based on their dates. We are also looking to color the events based upon different criteria (i.e. different teams...
  3. R

    Index and match

    Good Morning, I trying to use index and match to lookup and employee name based on the day of the week and their position. for example, I want to return the employee name who is in position "1" on Thursday. <tbody> Employee Sunday Monday Tuesday Wednesday Thursday Friday Saturday A OFF 2 3...
  4. A

    Vba macro help

    I don't know anything about VBA. I have a TAB called Christina I need to have this tab "Christina" automatically email to Christina every Thursday morning the report on this tab. Can anyone put this together?
  5. V

    determine if first Thursday of month falls on first week of month

    Hey Guys, I'm trying to output the dates of the weeks (Monday to Sunday) of any month given the following criteria: First week of month is if the first Thursday falls on the first week of the month. and correspondingly the last week if the next month's first Thursday falls on the first week of...
  6. H

    Date Formatting

    I need a formula that writes the current date exactly as below (Using today's date as an example) Dinner - Thursday 4th January 2018 ANY HELP GREATLY APPRECIATED I AM GOING MENTAL HERE LADS :rolleyes::laugh::laugh:
  7. X

    How To Forecast Delivery Day Based On Dispatch Day & Leadtime?

    Dear All, I do have a small data set across A1:C4 as follows:- <tbody> Dispatch Day Leadtime Proposed Delivery Day Thursday 7 Thusday Wednesday 4 Sunday Friday 8 Saturday </tbody> I would like to forecast the delivery day based on the Dispatch Day & the corresponding leadtime. For...
  8. X

    How To Calculate Conditional Mode On Text?

    Dear All, I do have a sample data set as follows(A1:B5) I would like to calculate the Conditional Mode against the Text in D1.C1 Contains Code(A). Pls suggest the formula which can populate the result in D1? <tbody> Code Day A Thursday A Thursday A Monday B Thursday </tbody>...
  9. R

    VBa code to subtotal by week ending date and monthly total

    Hello, Help needed in a report. The data is listed in columns as indicated below. I need to generate a report showing an end of week subtotal ending on each Thursday at close of business. The fields that I need to generate by VBA are listed below the data. I need VBA to make each column and...
  10. M

    Need auto generate using excel formula (index, match......)

    Table 1 <tbody> Sunday c d e Monday a b e f Tuesday a c d e Wednesday b c f Thursday b d f </tbody> Table 2 <tbody> a b c d e f </tbody> Table 3 <tbody> a Monday Tuesday b Monday Wednesday Thursday c Sunday Tuesday Wednesday d Sunday Tuesday...
  11. T

    work out shift from day and time

    HI all I need to update a formula to tell me shift Day / Evening or Night in Column V i have the hour, 1 to 24 In column W i have minute 00 to 60 in Column Z i have the Day Monday to Sunday Day shift is from 08.00 to 16.30 Monday to Thursday and 08.00 to 15.30 on Friday Evening shift is...
  12. S

    Can't get the like to compare

    I have 2 excel sheets one is a copy of the spreadsheet that google forms gives me. The other is one I want to update “Tracking 12 Mo MovAvg”. I would think the wild cards would qualify the “like”, but that is not the case. Any thoughts on what I’m doing wrong. Indents are not showing up in the...

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 MrExcel.com.
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 "mrexcel.com".
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
Back
Top