Auto populated list based on date range

**irfman** · 09-22-2020, 11:33 AM

Hi:

I have a long list of dates in column A of the sample atatched file. I am trying to find a formula which allows me to get desired output in column G that is extracted from column A based on the date selection (start to end) in column E. Hope i am able to clear my point.

Appreciate any assistance in the matter.

Regards

**Limor_OP** · 09-22-2020, 04:20 PM

Hi,
you need to give a few manual examples of the results you are expecting to see in your file as the written explanation is not clear enough.

Thanks .

**irfman** · 09-22-2020, 07:43 PM

I hope the following examples will be able to clarify my query.

For example, column A (1:25) has the following data:

Date
29-Dec-17
1-Jan-18
2-Jan-18
3-Jan-18
4-Jan-18
5-Jan-18
8-Jan-18
9-Jan-18
10-Jan-18
11-Jan-18
12-Jan-18
15-Jan-18
16-Jan-18
17-Jan-18
18-Jan-18
19-Jan-18
22-Jan-18
23-Jan-18
24-Jan-18
25-Jan-18
26-Jan-18
29-Jan-18
30-Jan-18
31-Jan-18

If I enter the start and end date in cell E1 and E2 as Start Date: 1-Jan-18 & End Date: 5-Jan-18 then output in column G should be:

1-Jan-18
2-Jan-18
3-Jan-18
4-Jan-18
5-Jan-18

If I enter start and end date as 25-Jan-18 and 28-Jan-18 respectively then the output in column G should be:

24-Jan-18
25-Jan-18
26-Jan-18

Auto populated list based on date range

LinkBack

Thread Tools

Rate This Thread

Display

Auto populated list based on date range

Re: Auto populated list based on date range

Re: Auto populated list based on date range

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Auto populated "frozen" date based on cell value.

[SOLVED] How to auto-populate a list based on a date range

[SOLVED] How do auto date populated in row wise

Auto populated same date

[SOLVED] Create Auto Populated list Field based off multiple fields

Auto hide populated date rows

[SOLVED] Can a cell have a drop down list and can also be auto populated

Bookmarks

Bookmarks

Posting Permissions