dec

Hello folks I am tracking the effect of using hormone disruption to control moths and I did 2 treatments, treatment 1 om May 12,2017 and treatment 2 November 17,2017.I want to mark off these 2 days on the chart so that the reader can see the effect of each treatment. Month Year-2017 Jan 6,2017...

I want a formula automatically to find the last 2 months of variable ranges and average the costs: I want to average Dec and Jan only; next month I want to average Jan and Feb so-on Oct Nov Dec Jan Second range Nov Dec Jan

Evening all, could someone help/point me in the right direction please?I have an excel workbook with approx. 30 spreadsheets on. 1 tab contains monthly costings and the second tab is a to Spreadsheet 2 (costings) <tbody> Development address Month (this column has every month for the year and I...

I am trying to do a formula for a date that shows the week of with Sundays date. I am using: =AC2-WEEKDAY(AA2,3) which returns the week of date as Sunday for my 2017 dates. For some reason when the date changes to 2018, the formula is then giving Monday as the week of date instead of Sunday...

I have two sets of months in a row, each column in that row is the next month. The first set of months is Jan thru Dec. The second set is two years of Jan thru Dec. In the first 12 months only one month will have a value, the rest is zeros. I want a formula that repeats the value of that one...

I have the following code to extract the current month - 1 month as well as the year .body = "Attached please find Sales Data by region as at " & Format(Month(Date) - 1 & " " & Year(Date), "mmm yyyy") & " vs the Prior Year" & vbNewLine & vbNewLine I would like this amended to extract the...

All, What best formula can be used to transfer this table below A1:B5 to table C1:O2? <tbody> </tbody> <tbody> A B 1 Month Cost 2 Jan 100 3 Apr 250 4 Jun 200 5 Aug 0 </tbody> This result what I am looking for as per table below. When B4 equal zero, B3 value...

Hi, A simple one Im sure for the wizards on this forum. Would someone provide an idea to create a macro to select todays month. Details are below: Column A has a list of multipe records by month (see Exhibit 1) I would like to create a macro that goes to today's month (i.e top of 'Jan 2018')...

Hi All, I have 2 workbooks with similar names in the same folder location. What i need to do is create a macro that merges the 2 workbooks together into one. So for example in the file location there will be the following excel files Adam Jones Dec 17 Adam Jones Dec 2017 Barbara Walter Dec 17...

Hi, I currently have this long string that I need the date extracted from. The date pieces for below is as follow: YEAR = 2017 MONTH = Dec (this is because January is 0 so in this sample Month=11 is Dec) Day_OF_MONTH=28 Would it be possible to have a formula that extracts the date and...

Hello Board, I was using this formula =0+MID(C2,5,6) to convert this Mon Dec 11, 2017 into this 12/11/2017. It worked up until 2018 came along. If I use it now, it will convert this....Mon Dec 11, 2017 to this, 12/11/2018. please let me know what is wrong.

I have a date ranges as per below. one range per cell. in the next column i have month and year from any of the below ranges. i.e Oct 2019 I need to count occurrence of of Oct 2019 in the third column in the row corresponding with the actual range, which is Oct - Dec 2019...

When I save a spreadsheet file to CSV, this week, it converts from 12/01/2017 to 12/17/18. I have tried saving the Dec 1 17 date in different formats but everyone yields a 2018 after reopening. Any help?

Hello everyone, I hope you guys can help me with this problem i am having that I need a VBA solution to! i have 8 worksheets (worksheets 8-15) that I need to be copied over to workheet3 ("RevRel") the data in all 8 worksheets has the same amount of columns (A:O) starting from A1 but vary in...

Hello I have a pivot table of waiting times and looking at the below for 2017, the grand total is wrong. When I highlight Oct, Nov & Dec totals, the average of selected cells (in the bottom status bar) says 3:29:19 Can anyone shed any light on why they're different? <tbody> Average Dwell...

Hi, I want to pull info from othersheets. Currently I use this and it works: =IFERROR(INDEX('NOV17'!$J:$J,MATCH('DEC17'!$B16,'NOV17'!$B:$B,0)),"") and another for each month eg =IFERROR(INDEX('Oct17'!$I:$I,MATCH('DEC17'!$B16,'Oct17'!$B:$B,0)),"") But I have to redo it every month and...

hi I am currently using this formula to calculate net pay. it only works on the first row cells. When I change to cell range it don't calculate properly. =(AF12+AG12)*Rates!$F$5-(((AF12+AG12)*Rates!$F$5-(11500/13))*0.2)-(((AF12+AG12)*Rates!$F$5-((157*4)))*0.12)-10 Snap of spread sheet...

Hi, The hour range is between store open times (Monday - Friday 09:00 till 17:00) If an order is placed we have a time of 6 hours to ship out the order. Example: An order is recieved Monday at 09:53, it has to be completed by 16:00 09:53 rounds up to 10:00 + 6 hours Though if an order is...

Can someone help me help me how to create a macro that would transpose the following amount in column to rows that match the dates, here is an example: Raw data from sheet 1: <colgroup><col><col></colgroup><tbody> Date Amount Oct 14, 2017 1 Oct 21, 2017 2 Oct 28, 2017 3 Nov 4, 2017 4...

Hi is it possible in VBA to convert a week number to the date range Monday to Friday that's with in it? I want to display the range of dates in a cell for example "dec 11 - dec 15" in a cell.