day

Hello all I hope you can help on this formula, I want to try to compare day on day sales comparison over 2018 / 2019 At the moment I have a sumifs statement that just adds up for each month and a running total for the year, it's fine for this year as it will add up to today but last year...

Good day Here is my code =IF(ISNUMBER(SEARCH(substring,text)), "Yes", "No") The result is in C6 (empty cell). When I put a number in A6 (empty cell). Then the empty cell C6 show the result. The substring is in B3. How to combine formula with my code above thank you

Hi all I have been asked to make a chart for staff in an office. Currently there are approximately 111 members of staff, however this is likely to increase in the coming months. I have prepared a workbook which has sheets for 2019 and 2020. Each of these sheets has the days of the year across...

Good Day sir, I am creating some formula to make my calculation easier. However i am stuck. :laugh: In the Sheet 3 (with yellow mark) i want cell K6 and K30 have same value with K18. I already have formula in there, but idk what else i need to add. This sheet is working on how many job that 1...

I have an activity start time variable, lrtime equaling 0.7708333333 (7:00 PM) I need to compare it to ensure that lrtime falls within the employee's shift. ie lrtime <= sel_crew1_end. The value for sel_crew1_end = 0 (midnight) sel_crew1_end = WorksheetFunction.VLookup(Me.cb_r1_crew & "1"...

Slightly complex and due to restraints i only have Excel to play with. I Want something like this: Tab 1: Data of jobs to be done Tab 2: All staff with how many minutes they work per day Tab 3: All product families we build and how long a batch will take to build in minutes then how many...

B2 gets updated by values due RTD B3 I have kept a flag which becomes 1 for a certain time period (ONLY ONCE DURING A DAY) Solution required: B4=HIGHEST VALUE of B2 when B3=1 else 0 B5= LOWEST VALUE of B2 when B3=1 else 0 How to accomplish? Thanks in adv

I have a workbook that has many sheets labeled by the date at such "7-1-19". Each day has a set of cells J3, K3, L3 with values that I need to graph per day. I'd like place them in columns with the date. For example 7-1-19 J3 K3 L3 7-2-19 J3 K3 L3 7-3-19 J3 K3 L3 ...and so...

Try this:Here's what I need. 16 golfers put into 4 foursomes every day for five days. Need every golfer to play with each other golfer only once example: Day 1 (Joe -Skip-John-Pete) Day 2 (Joe -Scott - Jason- Harry) Day 3 ( Joe - Craig - Dave -Ken) Day 4 ( Joe - Zilly - Chris - Ed)...

I have a macro running that seems to have run away and will not stop without control alt delete. Also ESC or CTRL-BREAK also don't work. IT's so weird. Sometime I will allow it to run over night and the next day it will be done and other times it will still be running. There is no rhyme or...

Hello, My power company exports my energy use by hour. I want to arrange years worth of data by day with all the hours of a day to the right of that day's row. That way I can compare energy use by hour and even by day of the week. What would be the best way to go about organizing this...

Hi, I need a formula which can pop up late if the individual has log in to system beyond 9:40 am, but if the person has left office at 9:00 pm , then he will get grace of 1:30 hour next day i.e he can reach office by 11:00 am next day but if he comes beyond 11:00 then he is late. Date...

Hello Mr Excel, I have a calendar that setup to look like a calendar. I need a normal look formula that could find the first day and the last day of an event. <colgroup><col span="9"><col></colgroup><tbody> sun mon tue wen thu fri sat look up a 26-Aug 27-Aug 28-Aug 29-Aug 30-Aug 31-Aug...

Hi, This is my code which works for the month but I want it to go from the 4th Sunday to the 4th Sunday of the next month. =SUMIFS($C$14:$C$1000,$A$14:$A$1000,">="&DATE($A$1,8,1),$A$14:$A$1000,"<"&DATE($A$1,9,1),$F$14:$F$1000,$AA1) Thank you AlanS.

I am working on a spreadsheet for my company that is requiring me to track the downtime of our trucks. I want to create/use a formula that will give me the time for 24, 48, 72, 96, 120, and 168 hours. So basically the total amount of hours would have to change everyday per formula. I have...

Hi, I want to know in a day & month a vehicle doing how many trips. Basically rotation of the vehicle. Abbreviation codes: Driver Code GU- Gurdeep G- Gafar G1- It will show the that driver done the multi delivery in this trip. For Example- On 2 June Gafar driver done four trips (G1 to G4)...

Hi all, I'm curious if there's a formula to do the opposite of DAYS360. That is, DAYS360 figures out the number of days between two dates on a 360 day basis. I want to make a formula that adds a number of days on a 360 day basis. So if my starting date is 5/25/19 and I add 6 days, it should...

Hi... I'd like to ask if someone can help me to find the correct formula. I have an overtime tracking template for 31 days, the threshold total hours for the month is 303 for 30 days which is 10.1 per day, if an employee worked from 1-31, the threshold should retain 303, but if an employee...

I have an extensive macro that builds a database from a number of daily files but it requires me to type a negative number into cell C23 and then I must click a button to run my macro. These negative numbers represent each past day eg. -2 produces the info for the day before yesterday and -365...

Hello forum, The title is a bit misleading. The dates I'm looking for are the last days of a month, however, EOMONTH won't work in this instance as the data is financial, so as such the last day of the month could be 29th April for example. I'm trying to find the most efficient way of...