wednesday

Hi all, I'm new to the forum so hi and Thankyou for any advice. I am currently working on a timesheet for my partner, the problem I have is the way the sheet works I have a column that accumulates any flexi time over 7 and a half hours but she has started doing half days on Wednesday only so I...

<tbody> A B C D E F G H I J K L M N F 1 Name Monday Tuesday Wednesday Thursday Friday Saturday Sunday Monday Tuesday Wednesday Thursday Friday Saturday Sunday 2 John 8 AM 8 AM 8 AM 8 AM 8 AM OFF OFF OFF OFF 8 AM 8 AM 8 AM 8 AM 8 AM 3 David 8 AM 8 AM 8 AM OFF OFF 8 AM 8 AM 8 AM 8 AM 8 AM 8...

Hello Folks, I am preparing a daily, weekly and monthly report. For weekly report I need a weekdays order from Thursday to Wednesday. When I pull data for this week in the filter it should filter from Thursday to Wednesday. Please suggest an idea whether in vba or formula. Thank you.

HI, I've been trying to come up with the formula to parse the date and time from this string of data in a cell, but can't seem to come up with it. Really hoping someone could help me with this formula: Here is the data in E1 cell: Date:</span> Wednesday, Jun 20, 2018 9:04:26 PM</div> Here...

I am doing a personal budget and wanted I40 and I41 to add together if the 25th of the month fell on a Saturday. <tbody> H I J 40 Car $445 25 41 Groceries/Gas $150 Saturday </tbody> Below you can see on the 25th of the month (Saturday) the $445 took (I27) but not adding in the $150...

Hi Excel users, here is an old question. Convert a text date to a date. I have the following text: Wednesday, May 23, 2018 This needs to be converted to a date: 23.05.2018. I have separated every variable: Day ( Wednesday) Month and Year using text function but I don't know how to proceed...

Hi Now I'm not sure where to start so here goes :-) I have a spreadsheet that has the days of the month split out Mon-Sun and i have used a formula to automatically put in the correct dates of the month above the correct day e.g. if the 1st May was a Wednesday then 01/05/2018 would appear...

Hi All I am stuck with this and need some help please. I have a sheet called Wednesday, and I am trying to find the last value (which will always be a number if it makes a difference) in column A of the worksheet. There will be blank cells in this column. so far I have :-...

Good morning all..... Done a lot of looking and have made some progress but stuck now.... My fiscal year does not always start on the same date....This is for some accounting reason...but it's been this way forever as far as i know... What i do know is that the fiscal year starts on the SUNDAY...

Hi, I have a 'draft timetable' sheet like this: <tbody> Harry Trumpet Wednesday 10:30 Wednesday 11:00 Jackie Saxophone Wednesday 11:30 Bob Flute Wednesday 12noon Jill Trumpet Thursday 10:30 </tbody> And 'final timetable' sheet that I want to look like this (no empty cells)...

Hi all, Based on a warranty date, I would like to Set a Date and Time Date should be at least 2 days before the warranty expiration date. If warranty date is a Monday, date should be at least Wednesday from previous week @ 10 am or 2 pm Days must only be Monday, Tuesday, Wednesday Time...

Hi, I have a set of data - example below - which I need sorting to show each day there is a delivery in the same postcode all on the same line; Data set example - <tbody> Postcode Route Drop Delivery Day AB12 3ZG <tbody> N3700 </tbody> 25 Wednesday AB12 3ZG <tbody> N3700 </tbody> 25...

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

Hi all, Im looking for a way using VBA code to transpose data contained in one cell separated by ";" to multiple rows. Below is an example of what im trying to achieve Event ID Day Start End Room 1 Monday 09:00 11:00 Room 1; Room 2; Room 3; Room 4 1 Monday 09:00 11:00 Room 1; Room...

Hello guys, I am trying to figure out formula that will show number of my work day in week, I don't have standard schedule. Instead i can work Mon,Tue,OFF,Thu,Fri,OFF,Sun or it can be: Mon,OFF, Tue, HOLIDAY,OFF, Fri,Sat,Sun. Networkday - only counts total days, workday - also doesn't give...