MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Dates Formula


Posted by Emma Shaw on July 27, 2001 1:31 AM

I have a list of regestration munbers in column A and the lease start date in column B , In column C I need a formula which will return the regestration number only if it is between dates 01/12/00 and 28/02/01 , Can anyone help, it`s driving me crazy!!


Posted by Aladin Akyurek on July 27, 2001 1:53 AM

Emma,

There isn't a single formula that would return which would return more than one registration number. I reckon that there will be zero or more reg numbers to return that fall between two dates.

I think it's better to use PivotTables or Data|Table.
If you insist of having formulas to do this, post about 20 rows of data that you have in A and B.

Aladin

Posted by Emma Shaw on July 27, 2001 2:06 AM

I have sent the file to your e-mail, I hope you can help

Posted by Aladin Akyurek on July 27, 2001 4:19 PM


Worked out file is underway to you. It contains an Advanced Filter solution along with an elaborate system of formulas that does the same thing as the former.

Aladin