date & range

Effectively, any of the office 365 equations *IFS do not seem to dynamically update when new information is presented in the range, they stick to the first answer given and then just repeat. The real formula is quite long and it works well enough (though I'm sure there are faster ways). I have...

Hi, I have a job sheet that enters the totals of a day. I need to average jobs completed each day for tracking. so sum each Tuesday and average against each other Tuesday. I have used the averageifs function but that is averaging the jobs within that day. This is the results page, with the...

I have a set of data (see picture attached), where different projects have several dates, even within same month (A3:B16). My goal is to build a ''calendar'' that will show Projects and their first date that will fit within the selected month. E.g. in the picture: I want to see the projects...

Have tried searching the forums but can't seem to word my question correctly. Here is a basic table:- Date Type Product Qty 01/12/2022 Order Blue Shirt 1 02/12/2022 Order Blue Shirt 1 03/12/2022 Order Blue Shirt 2 04/12/2022 Order Yellow Shirt 1 05/12/2022 Order Blue Shirt 1...

Hi all, I wondered if there was a clever/efficient way of checking if multiple columns with dates in, fall within a date range, see below table. I want to check if any of these dates fall between the 25/12/2022 and the 02/01/2023. I know I can do repeating if statements, but thought I'd check...

Hi guys, Trying to check if a date is between a range of dates in a table with date ranges. So, I have a table with two columns, col C is first day of vacation and col D is last day. And I'm trying to come up with a function to tell me if a given date is inside that range. I'm toying with...

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