feb

Hi, I have a table with for example 10 rows, in Col A is a name, In Col B is a formula which calculates the average of the next 52 columns. Each of the 52 columns represent a week of the year. I would like to achieve a couple of things here. I would like a cell, maybe A1 to have the year...

Hi all, I need to calculate how many Mondays, Tuesday's etc. an employee worked over a given time frame. It's not as simple as "tell me the # of Monday's between January and May.' See my condensed example using Thursday (i.e. how many Thursday's did this employee work between January and May...

Hello. I've searched all over and tried everything I've found to come up with a formula for the following: I have a master sheet with 200 or so User IDs, months of the year, and production data (the chart below is just a small sample). I want to be able to enter a User ID in cell B10 and a...

Good morning , friend How are you ? Like to learn (If possible), Excel automatically change from North to South for Jan, then, change automatically from Jan to Feb, and gives amounts for both North & South for Feb , then, change...

Hi all, I need to transform/ re-arrange data in Access. Below table illustrates the data that I currently have: <tbody> Year FY18 FY18 FY18 FY18 Month MAR MAR FEB FEB Country Channel Brand Item Number SLS UNT SLS CST SLS UNT SLS CST China RLS MSW 10004 34 $87.00 56 $80.00...

I've tried a selection of formulas, mostly trying VLookups and IF statements to pull the information I need but I don't seem to be getting the result I want. I'm trying do the following: I want to pull the highlighted date in Table 2 (keeping in mind table 2 is on another sheet in my Workbook)...

I am trying to write a formula to show quarterly payments for the next 5 years. The payment table is from starts in 2018. First payment is not until Feb 2019. A7: Feb-19 (payment start date) A8: $25,000 (qtrly payment amount) D4: 1/31/18 (across columns, 2/28/18, 3/31/18...etc to 2022) D5: 1...

Hi All, Starting new thread. There are (now) 7 sheets of data. Every sheet data contains monthly numbers. Till col A to F are fix. From col G onward.. Col G = Jan 18 Col H = Feb 18 Col I = Mar 18 Col J = Apr 18 Col K = YTD 2018 ....(next month col K will be May 18) Col L = Comments....(next...

<tbody> 1 A B C D E F G H I J 2 2017 2018 2018 2018 2018 Year 2018 3 Employee Dec Jan Feb Mar Apr Month Feb 4 Doe John 20.00 22.00 23.00 24.00 24.00 Employee Jones Mike 5 Jones Mike 15.00 17.00 18.00 19.00 19.00 Rate ??? </tbody> I have the above table (B2:G5)...

Hi Please bear with me on this one. I have a large spreadsheet (layout below) which tracks the sale of items (listed down in column A) by customer. Each customer takes a range of items, so therefore there are multiple instances of these items in Column A. In row 1, starting at cell B2 is the...

Hi All I have a table that is set up like this etc 2017 2018 Jan Feb Mar Jan Feb Mar Test1 5 Test2 10 Test3 20 This table has data stored every month with the amount of tests done I have a pivot table that just filters to give me which months...

Hi All I am trying to calculate given a varying starting day, the fall of every quarter or half year. e.g. 1 month= 1 (Jan) Type = quarter Next quarter = 4 (april) Similarly e.g. 2 Date = 1 Feb Type = quarter Next quarter = 5( may) or Similarly Date = 1 Feb Type = semi annual Next quarter...

<tbody> A B C D E F G From To Jan 1 Feb 1 Mar 1 Apr 1 May 1 Feb 1 Mar 15 no yes yes no no Feb 15 Apr 30 no yes yes yes no </tbody> Hello I have a table similar to above. I want to come up with a formula to populate "yes" or "no" from column C3:G4, based on dates entered in column A:B (in...

Hi, I am trying to analyze monthly income and volume data; problem is that the data is in following format <tbody> Client Name Income Jan 18 Income Feb 18 Volume Jan 18 Volume Feb 18 Visits Jan 18 Visits Feb 18 Client name 1 2343 43434 4434 42234 43234 23424 Client name 2 2342 242345...

Hi I am trying to write a formula that returns the date from a row that corresponds to the first cell in another row that is the first zero. The following example will help explain what I am mean. <tbody> Dates Column 1 Column 2 Column 3 Column 4 Jan 1 4 1 9 3 Feb 1 5 0 3...

Hi, I have been struggling with this and would be grateful for any suggestions. I have an email macro which runs down a list of recipients in column B and attaches a specified file in column C (saved to my desktop). This operates fine however the recipients have asked for one email with...

Hi , Have a clarification in excel formula. I have creating a template file now. It is related to hours Calculation. Concept is : Leader will update users extra working hous in a sheet. As per company policy all users should be extend 8 hours per month. If any one not extend 8 hours per...

I need to use the date of some fields that are imported from an RSS feed in Google Sheets. The date comes in as Tue, 06 Feb 2018 23:23:40 +0000 Using =MID(A1,FIND(",",A1)+2,256) I get the stuff after the comma, so almost there, but just need to ignore the time section 06 Feb 2018 23:23:40...

I have a workbook with twelve sheets named Jan, Feb, Mar ... Nov, Dec. Each sheet is similar and quite simple. Row 1 contains headings. Column A contains increasing dates beginning at row 2 and extending to row 29, 31 or 32 depending on the month. The next three columns (B, C, D) contain the...

Hi, I would appreciate assistance creating the correct formula to : SUM columns B, D and F ONLY if there are figures greater than zero in columns C, E and G (The result to find the YTD Budget in column H) I have tried numerous with not much luck! Thanks <tbody> A B C D E F G H Jan Budget...