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

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

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

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

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

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

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

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

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

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

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

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

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

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.

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

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