1/1/18

Hi guys, Is there anyway in VBA to say If Range("R67") = 1/1/18 then .SlicerItems("1/1/2018").Selected = True? Thanx

The data I have looks like ID. Date. Status 1. 1/1/18. Complete 1. 6/30/18. Complete 1. 12/31/18. Refused 2. 1/15/18. Refused 3. 4/30/18. Complete 4. 2/1/18. Refused 4. 4/1/18. Complete I...

Hello excel experts, I'm trying to figure out a way to have a countif formula that will capture number of unique dates with multiple criteria. Column D = Names Column E = Description Column F = Date Cell A2 = "John Doe" Cell A3= "Yes" Cell A4 = Formula to return the number of unique days...

I am trying to make a chart with some of the same dates and each date equals 1. I want to combine the same dates and have it add them all up. EXAMPLE: 1/1/18 1/1/18 1/1/18 1/2/18 1/2/18 So I want to combine the dates into a chart row and the column be the number of date's combined (1/1/18 = 3)

I am trying to type in a name in column D, and have the data from column B (for that name), generate in ascending order in column E. Any ideas? Is it an index match formula? <tbody> A B C D E F 1 Matthew 1/1/18 37 Mark 1/1/18 45 2 Mark 1/1/18 45 Mark 1/5/18 41 3 Luke 1/1/18 52 Mark...

Hello, I am trying to run a sum of "Net Cash" to "Dupe Sum". The criteria are that if the client ID and time of day are the same, sum the net cash in to "Dupe Sum"... Currently I am using this (=IF(AA2<>"",SUMIFS(AE:AE,F:F,F2,A:A,A2,AD:AD,AD2),"")) but it is also counting transactions that...

<tbody> 1/1/18 20 1/1/18 12 20 2/1/18 25 1/1/18 16 20 3/1/18 35 1/1/18 15 20 4/1/18 32 2/1/18 4 25 5/1/18 80 2/1/18 56 25 3/1/18 3 35 4/1/18 23 32 4/1/18 12 32 5/1/18 3 80 5/1/18 4 80 </tbody> So I'm basically trying to create...

<tbody> Status Date of joining Date of transfer Date of resign formula Active 1/1/18 =IF(ISNUMBER([@[Date of Leaving]]),"Resigned","Active") Resigned 1/1/18 1/31/18 <tbody> =IF(ISNUMBER([@[Date of Leaving]]),"Resigned","Active") </tbody> Transfer 1/1/18 1/15/18 Combined formula...

Hi Excel Geniuses, I need some help! Please note i am an excel novice. In chart 1 I have seasons that correspond to different time frames, sometimes they are the same. In chart 2 i have the units that should be in those months, sometimes they need to be added. And at the end is what i need...

Is it possible to conditionally format a cell to light up a certain color if there are any dates appearing that are beyond the year 2017? 12/31/17 is fine to not highlight but 1/1/18 and so on would be. How could I do this?