date2

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

Hi Everyone, Here i am trying to count number of weekends that are available in a particular month excluding 2nd and 4th Saturday I have the below code to check all the Saturdays and Sundays that are available between two dates but i need to exclude 2nd and 4th Saturday between those two given...

I'm trying to get data from Cell A4 in a closed workbook named "Test1.xlsm" When I use the name "Test1.xlsm" it gets the data But when I put the file name "Test1.xlsm" into a string it doesn't return the data from Cell A4 Sub LoopThroughFiles_for_Total_Values() Dim Date2 As String Dim...

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

how do we check via VBA or formula if dates overlap each other? date1: start date: 9-9-2018 end date: 10-8-2018 date2: start date: 9-22-2018 end date: 10-20-2018 date3: start date: 10-10-2018 end date: 11-15-2018 date2 overlaps with date1 while date3 overlaps with date2 etc many many thanks

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

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.

I have data like: Measure date1 date2 1 1 2 2 1 2 4 2 2 8 2 1 16 1 1 And I'd like to make a table like Dates 1 2 date1 1...

I use the formula =DATEIF(Date1,Date2,"md") Date1 is the oldest date, Date2 is the newest date "md" completed days excluding months and year; completed days as if the dates were in the same month and same year. The formular work fine in all other months except January in Date2. When the Date2...