Finding a date period

  • Thread starter Thread starter Howard Hoch
  • Start date Start date
H

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
 
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.
 
Back
Top