date & range

Hi there, Here is my example, I got a chunk of data in sheet1 here, it's a task list contain start and end dates for each task. (it's comes from my calendar as power querry so it may fill up any times) ABCD1Start EndMy TaskPriority222/10/202225/10/2022Task 1LOW323/10/202224/10/2022Task...

Hi, I am new to the site but hoping someone can help with ease... I have a tab in a workbook that includes a list of dates when a companys vacancies were given approval - column E. I have another column that provides for the date when the vacancy was filled - column O. I am looking to create...

I have a situation here with me and I need someone to help me to fix it. There are two textboxes which contain dates That is textbox1 and textbox2 Then I have two columns with dates as well. Thats columns AO and AP. AO3 and AP3 are headers with the labels START and ENDED respectively. Now...

Hi, I am looking for a formula that looks between two date ranges (that can be adjusted in cell B10 and B11 of the below) and return the COUNT of data within those ranges. If anyone can help with this it'd be much appreciated. Link to the Google Sheet here: Google Sheets: Sign-in Thanks Ryan

Hi all. Imagine range A1:A1000 with varying dates from 2020 to 2022 (short form 16-08-2021). Range B1:B1000 has number value for the corresponding date. In cell C1, show average of all values from current year (today()) -1. So in this case, effectively, return the average of all values from...

Hello, I have 2 columns. A = Date of arrival B = Date Of Departure I want a formula that will turn columns green when the dates are current and when they pass turn red. Created a travel tracking document and want to be able to see when my team is on the road and isnt at a glance. Thanks!

Hi everyone, I have a bit of convoluted question regarding multiplying dynamic amounts based on date and time conditions. I have tried a fair few different formulas including sumproduct, vlookup and ifs - but nothing gives the right answer. This is quite a large sheet so I have only copied...

I am trying to do a summation of how many labs occur per week from a daily count on another sheet. However, I can not get the summation to shift down 7 days at a time. Is there a way to do this? Weekly summary: From the Daily Counts: I need It to sum a week at a time like this. Then , the...

Hi, I have a list of data with employees and their holiday data ranges, which I want to transform into an array with weeks (showing week ending date - Friday) to show days of absence in that week Employee Start End Week Ending --> 03-May 10-May 17-May E01 30-Apr 15-May 4 5 3 E02 08-May...

Hello everybody, can you help me? If I delete the value of txtPrazoPagamento or the value of txtDateVencimento. I get this message: Run-time '13' Type mismatch Private Sub txtDataVencimento_Change() If CDate(txtDataHoje) > CDate(txtDataVencimento) Then txtAtraso.Value = Abs(DateDiff("d"...

Hi. I want to copy Date1 column to Date2 column. For Date2 column, I want the date to fill down blank cell until it find the next date. I have tried IF function and it is not working properly. Below is my table: AB6Date1Date274/4/2022891011/4/202211121314 Desired output...

How to add multiple date ranges to find the total time period in number of years , months and days 4/12/2015 to 6/2/2019 = 4 years,1 months,21 days 9/8/2010 to 1/8/2012 = 1 years,4 months,0 days 5/3/2007 to 3/4/2008 = 0 years,10 months,1 days 3/5/2004 to 4/3/2006 = 1 years,10 months,1 days...