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

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

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

Some videos you may like

This Week's Hot Topics

  • Problem with Radio Button's format control
    I am creating an employee evaluation template (a sample is below) Column A is the category Column B, C D, E and F will be ratings (unacceptable...
  • Last Display on userform to a Listbox
    [CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
  • Rename and move files to a new location
    Dear all, I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following...
  • Help with True/False Formula
    Hello! Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True...
  • Clear extra characters from a provided range of cells
    Dear All, I have following code which gives me desired output to remove extra characters from a provided range. But it takes too much time when...
  • Help with Current and highest streaks
    Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...
Top