Finding a date period

[Howard Hoch]

I'm trying to figure out the formula to zero in on specific dates.
I need to find any date in a column that is before a specific date <
=Today() >
Further, I need to export the WHOLE row (incorporating that date) to a
separate work sheet.
Any help would be appreciated.

Howard

 

[dave]

I would sort your entire spreadsheet by the date column,
and just cut the rows which are before today and paste
them in another sheet.
If you'd like to write a formula in a column next to your
dates so that you have a notifier of which dates fit the
parameter, then you can say [IF(a1<today(),"THIS
ONE","NOT THIS ONE")], and copy it down. Or you can use
conditional formatting.
I think the simplest way is to sort them.