Filter

[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

 

[Sandy Mann]

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

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.