nov

Hello experts! I don't know if it is too much to ask. I have a situation like the following: A2:A10 shows the timeline of a project. C2:C10 lists all working days between A2 and A10 excluding weekends (marked in red)and public holidays. C2=A2 but for C3 I have used...

Hi, I have 2 identical ranges (A25:BT44) in two different sheets (1 & 2). Users are allowed to enter data in any cell of the range A25:BT44 of Sheet1. The purpose of the same range in Sheet2 is to stamp dates of data entry. So I have the dates of each data entry in the corresponding cells of...

Hi, I use the same bit of opening code on just about everything I ever work on (I know there are a lot of different ways of doing this): 'Finds last row of data on the Altos billing Nov 18 calls Sheets("Altos billing Nov 18 calls").Select LastRowWithValueAltos = Columns("A").Find("*", ...

Hi all, I would like to use a VBA code so that to clear the numbers’ decimals which contains space before comma e.g. 26 ,7 should be 26 Therefore that, the code should run through col. “C4” : “O” and rows down. Please see below an extract of original data and the expected result. Thank you...

Hi I'm having trouble returning the correct values in the 2 cells shaded red in the below sheet. My objective is to show the ongoing corresponding number of miles cycled up to the same date in the previous year. The correct value for the current YTD total is the sum of cells C64:C93, which is...

Hi good people!, i'm trying to find a way to replace part of a formula by using a drop down. The formula is this:='G:\Flash\FLASH 18 - 19\NOV 18\The Ridge Flash\[The Ridge Flash - 21 Nov 18.xlsx]Slots Per Area'!$M$63 the drop down contains a list of months, so if i select "Jun", the "NOV" in...

Hello I have literally rubbed my eyebrows away trying desperately to create a dynamic line chart with columns A, G and H from the below data, so the chart shows only the most recent 90 calendar days entries (NOT the last 90 entries - please let me know if it's necessary to insert a daily entry...

I have to look up on table a rebate to subtract from salesmen gross sales. For one salesman I have multiple customers buying same items but not all get same rebates. For example customer infiniti naples buys item 01011 with rebate of $5, but customer dodge naples buys item 01011 with rebate $4...

I am currently trying to calculate the biggest time in a column for a specific month. Something like the following... <tbody> Month Offered Done Rc ave longest task Sep 1234 7525 125 45.57% 0:15:45 0:01:78 Oct 5481 5165 154 75.89% 0:45:15 0:05:98 Nov 1548 1568 525 98.99% 1:15:15 0:25:87...

Hello - I am building a table that I want to populate from another table, based on dates. On the first table, there are begin and end dates, job numbers, and a value. In my new table, there are job numbers in rows, and dates by day as columns. I want the formula to check if the date at the top...

Hi All, I can't quite get the 2 bits of formula to blend together.. any ideas? i have a table of values with Months across the top. In my example, I want to find the largest value for the current Month - the Month name 'NOV' is in a separate cell (B16) and changes each month. <colgroup><col...

Hi, Thanks for the help which you are going to offer me. My problem is I have a list of date values in the format "Sun, 11 Nov 2018 23:30:46 GM",, But I want to convert it to IST i.e GMT 5:30. The expected output is "11/12/2018 5:00". I have tried but couldn't get it done in...

Hi, I want to calculate when a long service award is due 6 months in advance based of today's date for each category, hopefully by highlighting the cell with conditional formatting. This is my data: <tbody> A B C D E F 1 Today: 22-Oct-18 2 3 NAME START DATE LENGTH OF SERVICE...

trying to come up with a formula that takes avrg Jan Purchase Price Less December price * Qty of JAN. my obstacle is that if there is no Dec price, to have the formula pick up Nov price. If no NOV price, then the last month and so forth... then I'll have the same for FEB price LESS dec price...

This is what my spreadsheet looks like right now <colgroup><col width="121" style="width: 91pt; mso-width-source: userset; mso-width-alt: 4295;" span="4"> <tbody> CELL K EMAIL DEPLOYMENT phase 1 if eff date is on weekend, forward to next bus day (no holidays accounted for)...

<tbody> A B C 1 Start Date End Date Today's Date 2 12 Sep 18 12 Nov 18 23 Jul 18 3 10 Jun 18 12 Nov 18 </tbody> How do you write a formula if you have dates in threedifferent columns. I am trying to determine if the ‘Start Date’ is prior to ‘Today’sDate’ and before the...

<tbody> A B C D E F 1 Initially Approval Issued Projected Begin Date Projected End Date Final Approval Today's Date 2 23 Jul 18 3 Yes No 22 Jun 18 10 Nov 18 Yes 4 Yes Yes 25 Aug 18 10 Nov 18 Yes 5 No Yes 18 Jul 18 10 Nov 18 No 6 No No 2...

Hi - To Simplify My Question A1 - Start Date A2 - End Date A3 - Contains 3rd NOV A4 - Result So In A4 I Want To Return The Result As Follows... If A3 (3rd Nov) Falls On Or Between The Dates Shown In A1 and A2 Then The Result Is "1", If Not Then The Result Is Zero Thanks

Hi I'm trying to list the dates that represent the begining of each week of the year but, when a week has two months, I would like to split it. I do not want to use vba to do that, just a single formula. The bold+underline cell in the table below is the starting date. In the second line and...

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...