01/01/2019

Hi I have in cell A1=1/1/2019 and I want to add 1 year to that date. So I did this B1 = A1+date(1,0,0) but I got wrong answer <tbody> 01/01/2019 02/12/2019 </tbody> Any idea why? I thought I should get 1/1/2020. Thank you very much.

Hello all I am trying to use a countifs statement to count the number of lines that match a date but i want to also include only unique lines. [=COUNTIFS(Data!Q:Q,C6)] This is the countifs statement in cell "E6" I also want to add the unique count to this formula which is in [Data!V:V] which...

Can someone assist with an Autofill code that autofill dates in column A for a specified year (i.e. 01/01/2019 - 12/31/2019) Thank you kindly

<tbody> a b c d e f 123 John Smith 01/01/2019 5/04/2019 No 12345 Simon Taylor 01/01/019 03/12/2018 No 43433 June Brown 01/01/2019 03/01/2019 Yes 234 Paul Baker 01/01/2019 No 12345 Rij Veech 01/01/2019 03/03/019 No </tbody> In Cell H1 I need a...

Hi guys i have the below table: if i have a date in A1 i want to get the max time for that date. Thanks <tbody> date time 01/01/2019 18:45 01/01/2019 18:45 01/01/2019 18:45 01/01/2019 18:45 01/01/2019 18:45 02/01/2019 08:23 02/01/2019 08:23 03/01/2019 08:24 03/01/2019...

Wondering if someone could look at the formula and help me. You can pretty much ignore everything up until where i am trying to get it to count the values between 2 dates. i know the formula works before i put the data range criteria in. Basically i had it working up until where Sales!R:R,"New...

Hi Guys I have the below data <tbody> A B C 1 MANAGER DATE STATUS 2 Roy 01/01/2019 Open 3 Roy 01/02/2019 Won 4 Roy 20/02/2019 Open 5 Roy 01/01/2019 Won 6 Roy 01/01/2019 Open 7 Roy 11/02/2019 Lost 8 Roy 01/01/2019 Lost 9 Roy 01/01/2019 Other 10 Roy 01/01/2019 Lost 11...

Hello all, I am looking to see if someone will help me create a macro that would flatten a data table (or move the data from rows into columns) by Name and Activity in excel. Basically I need to go from this (but there will be many different activities per name): Name - Activity - Start...

Hi there, <tbody> Name Submitted Assessed Bob 01/01/2019 05/01/2019 John 01/01/2019 31/01/2019 Fred 01/01/2019 20/02/2019 </tbody> I'm looking to use SUMPRODUCT function to count the number of records in the table above where the date difference between column B and C is less than 10...

Hello, I am trying to work out if this is possible, cantfind when googling but might be using the wrong terminology. I have the following workbook set up, what I want toautomate is, for excel to calculate the week num and then filter the columncontaining that value. , so in theexample below...

Hello, there is a code where I'm being struggling with. I have this: Range("A70").Value = Date If Range("A70").Value = "01/01/2019" Then Range("A71").Value = Range("A71").Value * 1.02 End If Withen an rivate Sub Worksheet_SelectionChange(ByVal Target As Range) But I...