Related:
- Copy row if value within date range diff wkbk
- Oracle date diff - Guide
- Saints row 2 cheats - Guide
- Apple airtag range - Guide
- How to delete row in word - Guide
- Insert a new sheet at the end of the tab names and paste the range names starting in cell a1. autofit columns a:b and name the worksheet as range names. ✓ - Excel Forum
1 response
A possible solution is:
In this example the formula is any cell in row 2, T2 contains the contract end date:
=IF(T2>NOW()+60,IF(T2<=NOW()+90,"Expiring",""),"")
copy this formula down all rows.
Any contracts that expire with the 60-90 days will show as 'Expiring'.
Now, once this is down, apply the autofilter and filter for those rows that show 'Expiring' in column T.
Then copy and paste the rows shown into a new sheet.
Or create a pivot table and filter it that way. This can be copy and paste-special values into a new sheet.
In this example the formula is any cell in row 2, T2 contains the contract end date:
=IF(T2>NOW()+60,IF(T2<=NOW()+90,"Expiring",""),"")
copy this formula down all rows.
Any contracts that expire with the 60-90 days will show as 'Expiring'.
Now, once this is down, apply the autofilter and filter for those rows that show 'Expiring' in column T.
Then copy and paste the rows shown into a new sheet.
Or create a pivot table and filter it that way. This can be copy and paste-special values into a new sheet.