oct

  1. W

    Formula to extract month and day and convert to month abbreviation and week number

    Hello. Seeking a formula to extract details from the CURRENT DATE START (E) cell to populate in the MONTH (A) cell and the WEEK (B) cell instead of me manually entering the month and week- appreciate your help in advance. Thank you. --- Michael <style type="text/css"><!--td {border: 1px solid...
  2. J

    Consecutive Max Occurrence Frequency of a Series and what column Max was Hit

    I have a series of quartile performances by month, an employee lands in a certain quartile for a month 1,2,3,4. I am counting the max consecutive occurrences of being in Q4, for my example below this occurs Jul, Aug Sep, Oct for a Max Consecutive Occurrence of 4. What I am struggling with...
  3. 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...
  4. C

    Workbook reference and incrementing cell location by 4

    <!--[if gte mso 9]><xml> <w:WordDocument> <w:View>Normal</w:View> <w:Zoom>0</w:Zoom> <w:PunctuationKerning/> <w:ValidateAgainstSchemas/> <w:SaveIfXMLInvalid>false</w:SaveIfXMLInvalid> <w:IgnoreMixedContent>false</w:IgnoreMixedContent>...
  5. S

    Copy Data from one Sheet to other sheet based on condition

    <colgroup><col><col span="2"></colgroup><tbody> The below data is in one excel sheet now I want to copy all data for Exchange House ABC and XYZ into Urgent sheet and rest to non-urgent sheet. Pls note the row number may very from Exchange house, I need to copy data from...
  6. M

    Counting occurrence of date in date range being string format

    I have a date ranges as per below. one range per cell. in the next column i have month and year from any of the below ranges. i.e Oct 2019 I need to count occurrence of of Oct 2019 in the third column in the row corresponding with the actual range, which is Oct - Dec 2019...
  7. S

    Averages not correct in pivot table

    Hello I have a pivot table of waiting times and looking at the below for 2017, the grand total is wrong. When I highlight Oct, Nov & Dec totals, the average of selected cells (in the bottom status bar) says 3:29:19 Can anyone shed any light on why they're different? <tbody> Average Dwell...
  8. T

    Turning text into dates with vba (or formula)

    Hi Everyone, So in column A I have text recorded like this "Oct 16, 2015 6:29:29 PM PDT" in column AA I want it to show just as the date "Oct 16 2015" not text but date Please help if you can Thanks Tony
  9. E

    SUMIF or IndexMatch?

    Hi all, A pretty simple question but I am stumped. Say I have "Room Revenue" for 30 days in the month of October. Room Revenue | 30,000 |1st Oct Room Revenue | 30,000| 2nd Oct Room Revenue | 29,000 | 1st Oct Is there any way I can get the final value to sum up all Room Revenue for 1st Oct...
  10. G

    Transfering Cells Values from one Workbook worksheet to another workbook worksheet. Provided all the relevent fields are there

    <tbody> Week Ending : Friday 20 Oct 2017 Supplier 1515 Purchase Order 2626 Date Detail / Course TrainingParent Sub Ground Sch / Device Time Training Venue Further Info Hours rate (£) cost (£) GL Code 15 Oct 2017...
  11. L

    oct 12, 2017 as a date

    Hi I understand excel will accept a date based on the computer settings. If I have my computer short date set as dd/mm/yy then excel will accept the same format unless i custom formatting it. So If my computer is dd/mm/yy then excel will accept 20/10/2017 but not 10/20/2017 (month can not be 20)...
  12. K

    Place excel shedule information into an excel mnthly calendar

    I have the following information that I want to use to populate an excel monthly calendar <tbody> stake out Mon, Oct 02, 17 0 Mon, Oct 02, 17 excavate Tue, Oct 03, 17 2 Thu, Oct 05, 17 layout/pour footings Fri, Oct 06, 17 2 Tue, Oct 10, 17 weaping, drain, rock/gravel Wed, Oct 11, 17 1...

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