day of week

  1. A

    Using MODE with Time and Days of the Week?

    Hello - #1) I am trying to derive the MODE of a sequence of times of day. In other words, I'd like to see what times of day are the most frequently occurring times, from a list of observed times. I have been given the following format to convert: 12:00:00 EDT I imagine it does need to be...
  2. A

    Deriving MODE from time

    Hello - I am trying to derive the MODE of a sequence of times. I have the following format to convert: 12:00:00 EDT I imagine it does need to be converted Into text or number format so as to derive the MODE of this sequence. I have tried several approaches to no avail. I also wish to derive...
  3. Smokeyham

    Counting Unique Number of Days

    I have a table with a large number of readings. Multiple readings are taken per day. I am trying to count the number of each week day on which we have taken readings, for instance "How many Saturdays have we been taking readings on." I have the dates entered into Column A. I tried the...
  4. T

    Conditional Formatting text colour based on day of week

    Hi there, I'm wondering if there's a way that I can format the text of a sheet so that it will automatically have a specific color relating to the day of the week the text is entered? For example, if I enter the text on a Monday it will be green, if I enter it on Tuesday it will be red, etc...
  5. G

    Trying to do some custom Pivot Table summaries, wondering if this is possible...

    Hi all, Pretty straightforward question, I hope. I have a data set that I'd like to see if I can get set up in a pivot table in a custom way. The data is being pulled out a SQL database and looks like this when I retrieve it (dummy data created for example purposes - its actually quite a bit...
  6. C

    Finding a holiday

    I'm working on a spreadsheet to estimate my paycheck. I know using =networkdays can help me find out of there is a holiday on any given week, but I need to know if it is on the mon, tue, wed, thu, fri, sat, or sun of the week so I can calculate holiday pay. I did it once before, but ended up...
  7. Q

    Date difference excluding days of week

    Hi, I have two dates, the start date and the end date. I need to calculate the exact date difference between them but excluding specific days of week. For example: Start date: 2015-10-06 11:00 AM End date: 2015-10-29 18:55 PM And all of Wednesdays and Fridays need to be excluded...
  8. Smokeyham

    Translate Dates into Text for Day of Week

    Hello, Using Excel 2007 I have a table which has dates and number of visitors. I wanted to translate the date into a day of the week. Easy enough I thought; just choose special formatting. That works, but I need the day to actually be text. If I copy the "day of the week" and paste...
  9. G

    [URGENT] Insert row based on day/time and then add text

    Hi All, I'm struggling with this situation described below: If the day/time on Column B and Column C falls outside the criteria shown below, then I need to insert a row before the next non blank cell, and insert the word "QUERY" in Column D. Criteria: Monday - Friday, 08:00 until 17:00...
  10. B

    Day Formula problem

    Hello all, It's been a while since I last posted mainly thanks to eveyone on here helping me learn so much :) However, I have a little problem that I'm not sure if there is a solution for. I'm using this formula: =DAY($D$5) which obviously returns as 0, in D5 I have the WEEKNUM formula. what...
  11. P

    Occurances within Date & Time Range - COUNTIFS

    Hi & Good Morning, I have a column (H) containing Date & Time as per the following: - 14/08/2013 06:51 14/08/2013 07:08 14/08/2013 07:11 14/08/2013 07:24 14/08/2013 08:32 15/08/2013 07:51 15/08/2013 08:51 15/08/2013 09:30 I've already got a Formula as follows to Count between Hours: -...
  12. B

    Pivot Table Day of Week Averages

    Hi All! I've been searching all over the place for a solution to this issue. While I found many similar threads, none have helped me resolve the problem, so I'm asking for your help. I have data arranged in the following manner (but it cannot be sorted this reliably): <tbody> Date Fruit...
  13. N

    Schedule with time sheet and budget all in one, but date and day not working

    hello i am building a monthly schedule with calcs weekly and monthly, i am using the below calculation. AL2 is the date 26/11/12 (always the 26th of the month) cell calcs= a2 =TEXT(E3,"ddd") .... E3=DATE(YEAR(AL2),MONTH(AL2),DAY(AL2)) .... e4=TEXT(E3,"dd") I need the sheet to show; the...
  14. D

    Cell Value Based on a Day of the week....

    Hi Guys I have a column A with dates eg: 2012/04/02 and I want to add a value into column B 120 but on a Saturday it must return value 80. So Monday to Friday must return 120 and Saturdays must return 80.
  15. L

    Date & Time Woes.

    Gents, Hopefully someone can give me some guidance on the best way to implement the following issue. I have a spreadsheet detailing phone calls being made from our offices. The spreadsheet has a column detailing the date and time the call was placed. The date and time is formatted as follows:-...
  16. K

    Get Dates for All Mondays in a Month

    Hello, I'm working on a project where I request a Month (always the first of the month) and a day of the week from the user. Based on that date and day, I want to write out all of the Mondays (if that's the day entered) of the month to separate cells. So for example, the user enters 4/1/2010...

Watch MrExcel Video

This Week's Hot Topics

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
Top