This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Hi,
This is my main table
| Publication date | Project Name | Start date | End date |
|---|---|---|---|
| 14-03-2024 | A | 14-06-2024 | 18-07-2025 |
| 20-05-2024 | A | 15-07-2024 | 18-07-2025 |
| 08-09-2024 | B | 15-07-2024 | 31-12-2024 |
| 06-07-2024 | A | 15-07-2024 | 16-08-2025 |
I have the publication date I want the user to select 2 publication dates which means I need to create 2 filters from the publication date so for example when filter 1 is selected= 14-03-2024 and filter 2 = is 20-05-2024
I need this as an output that shows the date shift of the start and end date of the project in comparison to filter 1 and filter 2 values
| Project name | Planned start date | Planned end date | 14-03-2024 | Actual start date | Actual end date | 20-05-2024 |
|---|---|---|---|---|---|---|
| A | 14-06-2024 | 18-07-2025 | 399 | 15-07-2024 | 18-07-2025 | 368 |
Processes in Microsoft 365 for setting up Office apps, redeeming product keys, and activating licenses.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Answer accepted by question author
=FILTER(A2:D5,(A2:A5>=A9)*(A2:A5<=A10))
Or this one
=TOROW(FILTER(B2:D5,(A2:A5>=A9)*(A2:A5<=A10)),,0)
Filter 1 and filter 2 is from publication date column the 1st one so column 1st
when publication date is 14-03-2024 start date is (Planned start)14-06-2024 and end date is(Planned end) 18-07-2025 and when publication date is 20-05-2024
start date (actual start )is 15-07-2024 and end date (Actual end) 18-07-2025so we will be comparing start and end date from 14th March with 20th May to understand the date shift(start and end date )
Could you share a test file?
You may upload to OneDrive or any other cloud Drive, then post a link here.
Which column to compare with filter 1 and filter2?
You may use FILTER function - Microsoft Support
=Filter(Table range, (column date>Filter1)*(column date<Filter2))