I have a column of expiration dates and a column of corresponding items on a 'Data collection' sheet. I also have a 'Summary' sheet which I need to create a report for my boss. I need a way to list items on the summary sheet based on date ranges. What I am looking for is something that does "IF 'Data collection' G1 is <=TODAY()+30 THEN copy 'Data collection' H1 and paste into 'Summary' D1, IF NOT then don't do anything. I need to do this so I have a neat list of items based on less than or equal to 30 days, 30 to 60 days, 60 to 90, and more than 90.
Bookmarks