weekday

I have a need to calculate two distinct attributes, by formulas (not VBA). Please note I am using UK date formats here. 1. Target Sign-Off Time. This should be calculated by adding weekday hours e.g. 24, 48, 72 to a date-time stamp in Excel. The logic needs to exclude weekend hours. 2. TAT...

Hi, Seen plenty of posts for formula for second Monday of the month or second Tuesday of the month. I want a formula for the second weekday in a month (weekday being a Monday, Tuesday, Wednesday Thursday or Friday)

Given the table, I have the following criteria (times in 24 hour): IF 6:00 to 10:00 AND weekday = Y THEN Category = 1 IF 10:01 to 16:00 AND weekday = Y THEN Category = 2 IF 16:01 to 20:00 AND weekday = Y THEN Category = 3 IF 06:00 to 20:00 AND weekday = N THEN Category = 4 There are no times...

Hi all, My goal is to count the number of a specific day of the week, say a Wednesday or Friday or Sunday between Date 1, say 1/10/2017 and Date 2, say 8/10/2017. A1: 1/10/2017 A2: 8/10/2017 Any thoughts on a formula to being able to count the number of specific day of the week between...

Hi all, My goal is to count the number of a specific day of the week, say a Wednesday or Friday or Sunday between Date 1, say 1/10/2015 and Date 2, say 8/10/2015. I actually have the answer, as this formula works to count the number of Sundays and does everything I need: =INT((WEEKDAY($B$1-...

Hi, I have a Worksheet that contains a list of colleagues and their annual leave. The dates are horizontal and they are all formulas referring to a date in cell B1. The formulas are in the format of =workday(C4,1). Some of these formulas are formatted as ddd to show the day of the week. What I...

I am in charge of a monthly worksheet for my company. We have what we call "7 habits of hospitality", each day of the week is a "habit". I'm trying to figure out a formula that will have the outcome: If Monday then "Be Dependable" will show in the cell. If Tuesday then "Guest Needs" will show...

Hi, Trying to add dates depending on if meets criteria. If the date is less than 7 days then I want the function to go to the next Thursday before. If it is more than 7 days, then it can leave on that Thursday date. Here's the equation I have...

Couldn't find anything that I would be able to build off of on here so I figured ill ask for some help. In Column D, the cell can contain things like "2x week" and "3x month" across multiple sheets in the workbook. Is it possible to create a code that would color the row that contains "2x week"...

Hello All! I am looking for help with logic for a formula. I am looking to do formulas for =Today()+1 for all days except Saturday - on Saturday I need it to be =Today()+2. I'm guessing this can be done by building an if statement with weekday and today built in the statement but I need...

I am needing to calculate holidays that I can use as part of the workday function. I used the following formula for Thanksgiving but need help understanding what it is doing so I can calculate these other holidays. =DATE(C2,11,1)+21+CHOOSE(WEEKDAY(DATE(C2,11,1)),4,3,2,1,0,6,5) --C2 is the...

Hello there, When I run a report for my company I get a file that contains 3 columns Date, employee and Shift I need to find out how many of each type happened on monday, tuesday, etc. <tbody> Date Employee Shift Aug 8, 2016 Bob Classic Aug 8, 2016 Sally Mini Aug 8, 2016 John Classic...

I've tried to find a formula, but I'm having trouble making any of them work for me. I'd like to try to calculate a date, but roll to the previous Friday if it falls on a weekend. B3 - Date C3 - Due x number of days before B3 D3 - Mailing Days (this would also be subtracted from the number...

Is it possible to derive 2 columns that contains only weekdays (dates and day) but excludes public holidays? eg if 4th July falls on a Wednesday can I derive a column automatically that lists like :- July 2 Monday 3 Tuesday 5 Thursday 6 Friday 9 Monday instead of July 2 Monday 3...

Currently I have my data show stats for the previous day. For example on Tuesday I show Monday's data, on Wednesday I show Tuesday's data and so forth. I need help making a formula where on Monday's I can show Friday's data. I don't need to show the weekend data. I've played around with IF...

Hello! I'm trying to have column B automatically update the day of the week (ddd) based on the date entered in A2. I've played around with the WEEKDAY formula, but I think I'm missing something. I was able to get the day to populate correctly using =TEXT(A2,"ddd") but it populates days when...

Hi all. A simplified version for the purpose of this question looks like this: <tbody> Date Day Red Room Blue Room 01.06.2016 Wednesday John Michael 02.06.2016 Thursday John Robert 03.06.2016 Friday William David 04.06.2016 Saturday Richard John 05.06.2016 Sunday Michael Robert...

Hello, I have the date in a number format (Ex. 3/19/16, based on my computer settings). I am currently using the following formula in cell O3, which extracts the weekday with no problem...

I'm using the WeekOfYear function in Power Query. By default, Sunday is the start of a new week. I'd like to have this changed to Monday being the start of a new week. Any ideas would be appreciated! Current formula: = Table.AddColumn(#"Changed Type", "WeekOfYear", each...

I spent last night looking for an answer to my question but i didn't find anything specific to my ask. I have a huge sheet that contains lots of data. In Column A, I have the Date and time. I would like to have a VBA code that does few actions. 1) Insert a column B next to column A that gives...