Filter

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a spreadsheet that contains a column of expiry dates and the next column has a formula to determine how many day's to go until expiry.

I would like to know a formula that I could use to filter out only the cells that fall into the criteria of 30 day's to go.

Could I also place this filter into a seperate sheet for ease of use

Bobby
 
Bobby,

If I understand you correctly, ( and I frequently don't), try:

=IF(Sheet1!A1<TODAY(),"Overdue",IF(Sheet1!A1<TODAY()+30,"Within 30
Days",""))

Adjusting the sheetname and range as required.

HTH

Sandy

--
to e-mail direct replace @mailintor.com with @tiscali.co.uk


Bobby Todd said:
I have a spreadsheet that contains a column of expiry dates and the next
Click to expand...
column has a formula to determine how many day's to go until expiry.
I would like to know a formula that I could use to filter out only the
Click to expand...
cells that fall into the criteria of 30 day's to go.
 
Back
Top