extract dates from a column of numbers

Please upload a workbook with sample data. This will help to understand the data structure and the best way to populated desired results i.e. formulas vs. vba code.

Thanks.

are there always 4 values between dates?

Try this..


In B1 use formula as..

Formula:

Please Login or Register  to view this content.

Its works exactly same as IsDate()
Drag downward..
Now you can filter only True..

a few assumptions
date will be greater than 18/02/1982 (just a date value i chose it =30000)
and values between dates are <30000
then in b2

Formula:

Please Login or Register  to view this content.

As per your spreadsheet example you can also use this formula for Excel 2003

In B1

=IF(ISERROR(SMALL(IF(INT($A$1:$A$35)=1,"",ROW($A$1:$A$35)),ROW(1:1))),"",INDIRECT("A"&SMALL(IF(INT($A$1:$A$35)=1,"",ROW($A$1:$A$35)),ROW(1:1))))

This is an array formula must be confirmed with Ctrl+Shift+Enter

that also assumes that values wont be 0.xxxx or 2.xxxxx anything other than 1.xxxxxx

You could try using Find and Select on the Home tab.

Select column A
Click on Find and Select, Find
Enter / as the thing to find
Click on Find All
A box will open in the Find dialogue that has a listing of all the cells found with a /
Click on the first entry in the list
Scroll down to the last entry and hold the Shift key down and click on the last entry to select all the entries in the list
Copy
Paste where you want the results.

You can also use a pivot table to create the list