mon

I have 2 columns on Sheet 2 In column A it says Mon all the way down to A10 Then Tues for a few more cells below, then Weds for a few cells and so on. The list is sorted in order To the right in Column B some cells have numbers in them and some are blank On Sheet 1 I want a summary, so it...

Hi everyone, Hopefully this can be done, and hopefully you follow what I'm trying to do. Sheet1 (for argument sake, columns = A - G, rows = 2+header) <tbody> LAST FIRST MON TUE WED THU FRI Jones Bob 5 5 5 5 5 Smith Ann 8 8 8 8 8 </tbody> Sheet2 (just references from sheet1...

I have 2 columns on Sheet 2 In column 1 it says Mon all the way down to A10 Then Tues for a few more cells below, then Weds for a few cells and so on. The list is sorted in order To the right in Column B some cells have numbers in them and some are blank On Sheet 1 I want a summary, so it...

I'm trying to figure out a formula for an attendance roster that will calculate the first M/W/F of a month. Since this particular class only meets M/W/F, I'd like to generate an attendance roster that for each month (each month on separate sheet) which finds the first day of the month that's...

Hi there, I am trying to retrieve all three of the cells in a range that start with the letters SS (Study Session). The sessions are numbered SS01 to SS30 in a much bigger sheet. <tbody> A B C D E F G H I J K L M N 1 NAME Num Study Num Careers Study 1 Study 2 Study 3 Mon 1 Mon 2 Mon 3 Mon...

I'm working with call center data. I have call volumes for multiple groups by date, using the TEXT function to return the day of week. Like so: 06/03/19 Mon Group1 1000 06/03/19 Mon Group2 1400 06/04/19 Tue Group1 1100 06/04/19 Tue Group2 1500...

Hi Everyone I Have a sheet called "Mon Wk1" That I need to copy to make every day of the week and for Wk1 - Wk5 so for example: "Mon Wk1" "Tue Wk1" all the way to "Sun Wk5" Please help if you can Thanks Tony

Hi there, Hoping someone can help, if my question makes sense. I have a formula (in B4) to look up the first value which appears in a row and give me a date from the matching column (apologies I dont know how to add formula and screenshots) =IFERROR(INDEX($D$3:$L$3,1,MATCH(A4,D4:L4,0)),"") A4...

What is the formula for getting the minutes between two dates Considering network days (Mon to Fri) and working hours (8am to 6pm)

Hi, I've trawled through the forum to see if I can find an answer on this but most apply to VLOOKUP which is not appropriate in my case. I have the following table where I want to add up the number of hours spent on each task, but, if there are no hours, I don't want a 0 in the total column...

Hi there Am hoping someone could point me in the right direction with a quick one. I have a list as below, and am looking to return the smallest or largest value by day: A B Mon 154 Tue 192 Wed 216 Thu 147 Fri 126 Sat 98 Sun 48 Mon 52 Tue 69 Wed 210 Thu 99 Fri 137 Sat 104 Sun...

"Mon, Mar. 11, 2018ABC, FGHO117 Comments" I want to extract from the above text string, "Mon, Mar. 11, 2018" in one cell, and "ABC, FGH" in another cell. Is it possible without using VBA? Thanks

Hi Guys, I have the following times of duty for our employees. What I would like to do is count the maximum number of employees that will be on site during the day. Can someone please help me? There are different employee number for different days. Data below shows 4 of the days. The actual...

I have a calendar that was built for me. Across one row I have "Mon, Tue, Wed, etc." I have the following formula that I am using which works fine for each cell... =TEXT(WEEKDAY(DATE(CalendarYear,4,1),1),"aaa") With this formula it will recognize that on the "1st of April" it will read "Mon"...

I need a formula that looks at the two columns below and gives me the result "Wed" as the max value Mon 10 Tue 15 Wed 20 Mon 15 Tue 10 Wed 20

I am creating a battle simulator for a crypto-game that I play (Etheremon if anyone is familar). I am able to pull a list of my possible opponents and all of their "mons" and respective stats using VBA. It looks like this: <colgroup><col><col><col><col><col><col><col><col><col span="5"><col...

Hi I want to use Repeat() to type "*". My question can I color these "*" to different color depends on the reading? Thank you. <tbody> day tmp =repeat("*",A2) mon 15 ************************ tus 10 ****************** wed 4 **** </tbody>

I have kept a personal exercise log for many years and I am trying to keep myself motivated (extract below). Column A12 contains consecutive dates exercised from 01.01.1999, and a row is added to this for every new day. Column B12 contains exercise activity. Mon, 8 Oct 2018 OTHER Tue, 9 Oct...

Hello Gurus, Seeking your expert help in writing a Macro. Am a newbie. I have a below table: <colgroup><col><col><col><col><col><col span="6"></colgroup><tbody> Sold On Mon Tues Wed Thu Fri Sat Sun Item 1 Apple 10 20 30 40 50 60 70 2 Banana 11 12 13 14...

In column B2:B157 I have dates In column C2:C157 I have =CHOOSE(WEEKDAY(B3),"Sun","Mon","Tue","Wed","Thu","Fri","Sat","Sun"), to give me the day, B3 is a specific date What I want to do in another worksheet is count number of mon, tues, wed,... in a given month. So the result should tell me...