if i want to have dates falling in a particular range.

If i provide the starting date and the ending date , then is it psossible for me to check whether any date falls in that range..

Lets say the starting date is 1-Aug and the endin date is 10-Sep then i need to extract only those dates from a list of dates that are falling on 1-aug and btween and equal to 10-sep.

The dates would be anything like 1-aug-2000 31-aug-2007 .the year would be of no importance as i will be only providing the starting date and ending date without the year..

So anyone..??

What do you mean "extract"?

Do you want to list all the dates that fulfill your criteria, or just count them? You say the year isn't important but do you want to see the year of the extracted dates?

Originally Posted by daddylonglegs

What do you mean "extract"?

Do you want to list all the dates that fulfill your criteria, or just count them? You say the year isn't important but do you want to see the year of the extracted dates?

i dont want the count i want all the dates listed one below the other with their year , however i dont want to consider it while doing the calculation.

i dont know how else can i explain but i want to create such a logic to get all the records falling in the range and im creating the range dynamicaly by using the function [ =TODAY() ] in the cell B2 in the Sheet2

Its like a multilookup + getting the date condition right.
I actually need to have only the logic for the date i can convert it in Multilookup...

Please revert back for any clarifications...

Perhaps this will help.

D1 and D2 are the criteria, these can be any dates, year is irrelevant.

Dates are listed from C4 down. These are listed in the order they appear in column A but the formula could possibly be changed....

Originally Posted by daddylonglegs

Perhaps this will help.

D1 and D2 are the criteria, these can be any dates, year is irrelevant.

Dates are listed from C4 down. These are listed in the order they appear in column A but the formula could possibly be changed....

Daddy Long Legs u were excellent this is exactly what i was looking out for..
Thank you ver much, i am really grateful to you as i want to use this logic in one of my Insurance sheets..

I will b using this logic to keep a check of all the premiums which are due and which have one month grace period..

I am attaching the file for your reference i really like the way u helped me but human mind is always full of desires and need more help to make it more complete.

Fine i got the dates falling in the range but what about the data in the adjoining columns how do i get it and what if i keep a drop-dow in the column C2 and have three options in the drop-down such as first blank,All,=today()..

then what i want is to show blank if any of the cells b3 or c3 are blank , if the cell c3 contains "All" then show all the records and finally the last option which you have already worked upon.

Originally Posted by all4excel

I am attaching the file for your reference i really like the way u helped me but human mind is always full of desires and need more help to make it more complete.

Fine i got the dates falling in the range but what about the data in the adjoining columns how do i get it and what if i keep a drop-dow in the column C2 and have three options in the drop-down such as first blank,All,=today()..

then what i want is to show blank if any of the cells b3 or c3 are blank , if the cell c3 contains "All" then show all the records and finally the last option which you have already worked upon.

can someone please go through the file and help me.
nction but it does not work the way i want ti.

It works fine for all range of dates except a certain few.
For ex:-
If u type a date as 1st jan 2007 then it cannot pull the data as it goes 10 days back in the previous year and 30 days ahead in the next year.

but when understanding the range it is critical in this scenario to have the year to take it as a continuos date ..

Lets say i enter 1st jan 2007 and i have dates like 14th jan 2003 which sud ideally get pulled but it doesn't...

Daddy long legs can u please suggest a solution.