date range check

Hi, I require a formula in C18 (Red) That uses the date in C18 (Green), searches it within the date ranges of Columns D and E, and produces the result of Column G depending on which Row that date falls on. Thanks in advance.

Hi, I have the following fields / inputs: 1) 'Start date' - in this example 9 June 2023, cell AV11 2) 'First date' - in this example 1 July 2013, cell AU16 3) 'Frequency' - 365.25 (in days), cell AV14 --> this can take any numeric value, and would typically range from 1 to 365.25 I have...

I am trying to see if a date is before, during or after a specific date range. For example: A1 16/01/2020 A2 01/01/19 B2 31/12/19 A3 01/01/20 B3 31/12/20 A4 01/01/21 B3 31/12/21 I need a formula for C2,C3 and C4 to see if the date in A1 is before, during or after each range. So in this...

Table 1: <tbody> Date Code Price Ideal Price 01/01/2017 7 ? 0 02/02/2017 4 ? 0 03/03/2017 7 ? 80 </tbody> Table 2: <tbody> Sale Date Code Price 01/10/2017 4 $70 03/02/2017 4 $65 03/06/2017 7 $80 </tbody> I want to populate table 1 prices based on a combination of...

I have a workbook with multiple sheets. Each sheet has the dates listed in column A (1/1/17, 1/2/17, 1/3/17 etc). In columns B:K are yes or no answers for each date. I am trying to create a summary sheet that lists the total number of Yes answers for each month and the total number of no answers...

Morning all, I've been using a great piece of code given generously on this forum, however the structure of the file has now changed and Ive altered the code but the script keeps giving runtime errors. The file has the following user input cells: F1 = Date from H1 = Date to (so the user can...

I have a data set where I am trying to get excel to recognize when two data sets overlap one another. In both tables I have an Activity, a name, end date and start date. If two date ranges from the two tables overlap, and the names of the two people match, I want that row to highlight. The...

Excel 2010 question: I have a table that I'm trying to write a validation formula (using Excel formula and avoid VBA if possible)for. In the example table below - the "Assignment" given to the unique combination of "Account" & "Sub-account" for an over-lapping Start and End Date must be the...