day

Hi In my team we have a daily set of data which we need to analyse and send to the teams members. As the summary of analysed data is sent by email I want to send it in a way that the data has borders on it. In terms of columns, it goes from column A to L. In terms of rows, data will vary from...

Hi All, I have some percentages for 3 weeks for 3 different Areas in Area 1) B1:V100 Area 2) AB1:AV100 Area 3) BB1:BV100 now what i want to do is get the 5 largest values for each day 5 largest for each day ie B1:B100 C1:C100 D1:D100 etc Now i know i can rank them and use a countifs...

I have the date in this format "Day: 11 Sep 19", just need date from this "Day: 11 Sep 19" in format as date format 11-09-2019 any idea.

Hi all, I have got an interesting problem . I have got a sample Data below: <tbody> A B C D E F G H I 1 1 2 4 4 1 2 2 3 4 2 13 3 5.5 </tbody> I have got a target number in A2. I need to find how much of the range A1:I1 that number would cover. Each cell in the range...

3 columns 1 row: $X1 $Y1 $Z1 If there's a number in any of these, l want to trigger a concatenation involving the data in that specific cell. The row will be filled in left to right. So, if X1 is empty, then Y1 and Z1 will be too. If Y1 is empty, then Z1 will be empty too, but X1 may have...

Hi, I'm creating a spreadsheet with a list of all my employees, however rather than updating their availability daily, is there a code so that their shift is updated depending on the business day within every 2 weeks? Ex: Employee A is off on the 1st and 2nd Wednesday every 2 weeks, so when...

I have the below but i also need it to count days between Out Date (H6) and Return Date (J6) if J6 is blank on G6 will have the day count using today date until a date is put in J6 =IF(ISBLANK(J6),"",IF(ISBLANK(H6),TODAY()-H6,J6-H6))

Alright guys, I'm pretty new to VBA and am working on a fairly simple userform to display data from multiple sheets in one place. I need help with one aspect, I need to convert days of the week to actual dates. The trick is I need to find the next available day of the week based on today's...

Hello, I have a workbook with multiple sheets. Each sheet is one 'job'. Each job can have several different employees in column A, and then the rest of the columns are for hours worked (example col B is Monday day shift, C is Monday afternoon, D is Tuesday day shift, etc). I want to be able to...

Good Afternoon, I currently have a list of dates starting in cell A2 which lists every day of the current year (1/1 - 12/31). I also have some named ranges that reference columns A:U for each month (Ex: January is A2:U32, February is A33:U63 etc) . I'm running into an issue where since next...

Hello guys, I have a file at work that has interesting functionality. It has a minimize set up for each month that you can expand to see per day. It's very convenient and i would like to replicate it, but I'm not sure what to even google for, maybe you have some ideas? Image of what i mean can...

I'm brand new, and struggling. I want to create a drop down menu for a user building a calendar. For example, when the user selects "Weekend" from the drop down menu, the cells within the calendar day are all changed to gray. When they select "Week Day" then it allows the user to make inputs...

Hello~ I've created and administer an Access DB application -- 20+ end users -- split db -- each user has a copy of an accde executable file on their desktop, while the back end is on a network server. The front end is programmed to shut down automatically @ 8pm every night. Once in awhile...

Hello I'm trying to do a sumifs formula based on 2 criterias. The first is a name. the second one I can't do is when the date DAY is lower than 15. For example in the table below I want to get the sum of A only lower than 15, the result should be 2.000 I was trying something (hardcoded just...

HI ALL, I'm planning to use some formulas to return my employee's schedule which looks clean and more simply from a complicated database. Here are what i have in the original schedule @ sheet_schedule for my 3x employee and a formula to return a concise layout @ sheet_result formula in...

I have moved past the issue of time to decimal, as that was handled quite efficiently here. I am now on to a new "I need help" thing. I would like to have a yes or no question box pop up upon opening the worksheet (or workbook or speadsheet, not quite sure of that terminology yet) which changes...

Hi, Could somene tell me if there is a way to sort a list of jobs that are required to be done over a monthly period (per day) I have a list of tools and how many hours they have been used for, i'd like to be able to plan how many jobs i can do per day ( 3,4,5,6) is there a formula i can use...

By chance, I discovered that Excel doesn't warn you if you declare a variable with the same name as a built-in VBA function. For example, the following compiles without errors: Sub myProcedure Dim Day As String Day = "Monday" End Sub But now, the "Day" function cannot be used. I get...

Good morning excelites, I need help with a formula to average data for a given day based on the data below. I need to first identify what day of the month (Mon, Tue etc) a day number falls on in any given month and then average those days out. For example, in the table below "Day of Month" in...

Hi, I hope you can please help me? I have a Macro which one command Filters all Rows in Excel Sheet which show P in ColD. I need the VBA Code to Delete those exposed rows only which can vary day to day and then afterwards to Unfilter sheet.