date1

Hi all I have extracted the date from a file name using the following code Date1 = Right(Left(Name, Len(Name) - 4), 9) I now need to use this text date to create a date in DD/MM/YYYY format so using Date1 i tried this Date2 = Left(Date1, 3) & "/" & Right(Date1, 6) which failed doing...

Dear all; How can I solve this error: Sincerely. "Application-defined or object-defined error" I have two sheets, "SETUP", "RESULTS". Setup contains the information. Sub Mine() Dim out() As Double Dim date_a() As Date Dim dt As Double Dim I, start, n, j As Integer Dim...

I have an error in my code but I don't know where... The thing is that I never know which name will be in the cells and I want it to be linked to the name of the sheet. I always have an error on line 6 but I don't know why. This is a part of my code: For x = 0 To 10...

Hopefully a quick one. I'm referencing a date (31/12/2018) as a variable "date1" I'm then going onto another sheet and saying if the value in B is >= date1 and <= date2 then do this. When I set it to 31/12/2018, even though this cell is less than the value in B (which is 07/01/2019), it...

Hi, I have a register (attendance) with columns as follows: Name | Yr Grp | Date1 | Date2....| Date 10 What I want to do is count the number of rows where Yr Grp=N (a number) AND where the count of Date1 to Date10 =P (present) is greater than 7. i.e. how many people (each row is a person's...

Hi guys, first time poster here hoping to get a bit of help on a problem. I have a workbook with four sheets similar to this format: Sheet1 SampleA1 SampleA2 SampleB1 SampleB2 SampleC1 SampleC2 Sheet2 ID Date A1 Date1 A2 Date2 Sheet3 ID Date B1 Date3 B2 Date4 Sheet4 ID...

Good day, I am trying to find out what percentage of individuals did not hit a particular condition on the same dates, particularly when one individual is removed from the equation. This sounds so simple but it's driving me mad trying to figure it out. I've tried both PivotTables and SQL but...

My code below works greate when I'm importing a file that has the same date as the date when I run the import. For example, if I run the import on 06/01/18 and the filename is TestDate_060118. xlsx, Access will import and append file to existing table. If the filename is TestDate_053118.xlsx...

Hi all. I have the following problem: I have a table and for each record there are multiple date fields. Here is a brief example (these dates use the British format of Day/Month/Year): <tbody> Date1 Date2 Date3 Date4 Date5 Date6 06/09/2017 03/11/2017 06/10/2017 28/09/2017...

I need help with a Nested IF formula. If Date1 = Date1 + 7 days and Date2 is Blank, then "Return Window Closed", If Date1 < Date1 + 7 days and Date2 is Blank, then "Awaiting Return" if Date2 is not Blank then "Return Received". If Date1 and Date2 is Blank then show nothing on the cell.

Hi Guys can you help me ? I have data on a worksheet as below Product Date1 Date2 Date3 Apple 2 4 0 Banana 1 3 4 I need to get the data in the form, I have around 11000 rows. Using Excel from Office 365 Version 1711 Build...

Hi there, I have a worksheet with 5 dates in cells (A1, A101, A201, A301 & A401) - they are all formatted dd/mm/yyyy I need to copy the date from these cells to other cells on another sheet but change the formats to yyyy-mm-dd - I thought I could use: Date1 = Sheets("Sheet1").Range("A1").Value...