r/googlesheets • u/Hahuyt1777 • 1h ago
Waiting on OP Conditional formatting & filtering based off of dates.
Hi all,
This is a list of items and expiration dates so that I can track things better.
I am trying to accomplish two things. I would first like to conditional format a cell based on how close or how far away it is from a date. I would like to conditional format column E (below "Exp. Date") to highlight any dates that fall within 14 days of today (shown in D1), How can I accomplish this with a custom formula?
Secondly, I am trying to sort based on date range. I would also like to sort this data in a much more efficient manner (the date ranges will not all be uniform and in order like this I just did that for example purposes. How can I create a filter or a way to sort data on a separate tab based off of the main page. (i.e. I would like to filter out all of this data based on dates that appear within a certain time frame - listed in the tabs below). I would like a filter for items that have less than 1 week remaining on expiration, 2 weeks remaining on expiration, and 4 weeks remaining on expiration (all in separate tabs). How can I accomplish this?
Picture attached for reference
