01/01/2017

Hi, Could you please help with VBA code for below condition If the date in Column “I” is between 01/01/2017 to 12/31/2017 and Column “H” is >=0.50 Column A should display as A else D

Hi Guys, Lets say you have 20 Dates, 10 for each year: 2018, 2019. You also have two ID's. I'm trying to find the earliest date in 2018 and the earliest date in 2019, in which each ID appear. MIN, MAX wont work, as the dates can be in the future or in the past. The data also isn't sorted and...

<colgroup><col><col><col><col span="17"></colgroup><tbody> I need some help I have a training spread sheet. On the left i have a list of names. The the right of the names i have a series of columns...

Hello, I have a data set with over 60,000 lines of data per year. It contains the date and time an object was placed in a specific container and for how long it was in the container. The more objects that were simultaneously together in the container the greater the weight and loading on the...

Hi, Im trying to count all the people in on total people column and then trying to count them again but using there ID. But if it comes up twice to count it as 1 in a date range. Im using a Raw data download of about 4000 records and trying to stay away from an array formula that does work...

Morning, I have been using some formula i have found on here. =MAX(0,1+MIN(EOMONTH(F$1,0),$C2)-MAX(F$1,$B2)) But when i put it into my table it adds the numbers from the previous month: <tbody> A B C F G Ref start end 01/01/2017 01/02/2017 548782 04/01/2017 05/01/2017 2 2 563762...

I need to find the number of months between 2 dates, I have tried "DATEDIF" but this does not give what I require, below is what is needed <tbody> A1 B1 Months 01/01/2017 29/01/2017 1 01/01/2017 01/02/2017 2 01/01/2017 28/02/2017 2 01/01/2017 01/03/2017 3 </tbody>

I am sorry for what I am sure is a simple question, but nothing I try seems to work. I have approximately 8000 rows in an excel table formatted as follows: Date and Time 01/01/2017 0748 01/01/2017 0749 01/01/2017 0750 01/01/2017 0751 01/01/2017 0752 I need to split the date and time into two...

Hello Everyone. I have a spreadsheet that looks similar to below <tbody> Name Date Number 1 2 3 Of Property Acquired of Units 352 352 525 River City 01/01/2017 252 Place Landing 03/06/2017 200 Village Green 01/01/2017 100 </tbody> I have a formula in D3-f3 to total the...