tuesday

Hi I have a range of dates in the range G7:G16 but not necessarily in all rows. I would like a formula to total the number of days only for Tuesday, Wednesday or Friday. That is a complete total not how many for each day. Many thanks

If I calculate a Due date and it's a Sunday is there a formula to push it to the next Monday, if it's a holiday can I push it to the next Tuesday?

Hi, I am trying to calculate the next available delivery date , either Tuesday or Thursday based on the date given in Q10 first but N10 if there is a date entered The delivery slots would be only weekday Tuesday or Thursday, excluding the weekends many thanks for any help

Hello, I'm trying to get this to work. I tried the vlookup, combination of Match & Index, but none helped me to achieve the desired output. I'm missing something. Here is my lookup table1 with "Holiday" details in the third column. Instead of "Holiday", the column might contains other...

I have the date as follows in three columns in individual cells col A row 2 = 22 Col B row 2 = May Col C row 2 = 2018 How can I get Tuesday in col D row 2 ( now I enter it manually) Thanking you AFD

I have a team of 6 people i would like to do the following to show how many employees i have working between 6am - 6pm. Here is a sample of data i have employee 1 Monday 8:00am - 4:00pm Tuesday 8:00am - 4:00pm so on. employee 2 Monday 9:00am - 6:00pm Tuesday 9:00am - 3:00pm so...

Hi, Can someone help me figure out a formula that will calculate the date of each Tuesday of the month that I have in Cell A1? For example. In Cell A1 I have the number 5 to represent the 5th month of the year (MAY) what formula should I put in the next 5 cells that will pull up the 1st...

Hi, I'm wondering if anyone can help. I have a userform which has days of the week (mon through to sunday) as a selection and whatever day is selected is entered as a text into a cell... what I want to do from this is work out the actual date of the previous day that has been selected: i.e...

So I may be over thinking this, but I need a formula that will take any column with the header MONDAY and sum rows 4-6. <tbody> A B C D 1 MONDAY MONDAY TUESDAY TUESDAY 2 AM PM AM PM 3 A 50 250 200 100 4 B 100 100 250 50 5 C 50 100 50 200 6 D 200 200 50 250 7 E 200...

Hello, It is hard to explain, but I need to create a table, that says exact dates of some schecules. The patients that I discharged from hospital Needs to see me in 25 weeks later, but exactly that week's Tuesday. =Today()+175 this code not helps me because I discharge patient in different...

Is there an easy way to replace a portion of a string without using left/mid/right functions? The best way to explain is by example. Lets I have in a cell, "Tuesday is the best day of the week," and I want to input into another cell, "Tuesday is the worst day of the week." Is there a simpler...

Hi all I am looking for some help, regarding trying to calculate the next Tuesday following a certain date. If I explain the process it might be easier, currently we have a multi stage (7 in total), process that is connected to the previous stage, and 3 of these stages can only happen on a...

Is it possible, because I don't think it is, to have more than one sheet with the same name, for example - 2 sheets named Monday, 2 sheets named Tuesday

Hi all experts. I have some data in the following way for which I'd need to get some percentiles: I'd like a formula which could help me get the .5 percentile of the Rates (Column F) only of those which meet the following criteria: Process = Lift (Column B), Day = Tuesday, I know I have to...

I have a table which contains schedules for my employees, broken out into their start and end times. Like so: <tbody> Employee Monday_Start Monday_End Tuesday_Start Tuesday_End Bob 09:30:00 18:00:00 09:30:00 16:30:00 Alice 08:00:00 16:30:00 08:00:00 16:30:00 </tbody> And I...

Table 1 <tbody> Sunday c d e Monday a b e f Tuesday a c d e Wednesday b c f Thursday b d f </tbody> Table 2 <tbody> a b c d e f </tbody> Table 3 <tbody> a Monday Tuesday b Monday Wednesday Thursday c Sunday Tuesday Wednesday d Sunday Tuesday...

I'm needing a formula that, starting with today (whatever day that may be), returns the date of the following Monday unless it is a holiday, then Tuesday. It would save me so much time if I didn't have to change all the dates on a bunch of paperwork weekly.

Hi everyone, Can someone help me out, I need something like a today formula that excludes weekends so when monday comes it will automatically just give me Friday, then on Tuesday it gives me Monday etc Thanks!

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)

Dear All, I do have a sample data set across A1:D4 as follows:- <tbody> Inward Date Inward Day Schedule Type Inward Day-Desired(With Formula) 01-Aug Tuesday A Tuesday 02-Aug Wednesday B Wednesday 04-Aug Friday C Friday </tbody> There is another table with the Schedule Type across...