1
I have a delivery spreadsheet that contains a column with dates as well as other information. Is there a formula that can be written that would remove a row of information after the entered day is five days past?
Curt Jackman
Posted 2018-03-12T15:51:47.143
Reputation: 11
1No, there is no formula that will remove a row. You will need vba. – Scott Craner – 2018-03-12T15:53:17.067
Furthermore, while you might consider using a filter to hide a row instead of completely removing it, the auto-filter feature of Excel works with fixed value, not formulas like five days past. – AntoineL – 2018-03-12T16:09:46.527
1However, filtering raises two possible solutions although they are awkward. One is if you already have a column with the number of past days (or if you can add such a column): you then can filter on this column being less than 5. Another way, more complex, is to use conditional format to highlight in some way (font colour or background colour) the cells where the entered day is five days in the past (less than
=NOW()-5), then to filter out on that colour. – AntoineL – 2018-03-12T16:11:35.940mind sharing any sample data/file to clarify which cell does the "entered day" & "information" is located? ( : – p._phidot_ – 2018-08-10T06:54:33.703
or try this.
– p._phidot_ – 2018-08-13T12:20:19.137