Excel date conditions

Chantalehoney Posts 1 Registration date Friday April 20, 2018 Status Member Last seen April 20, 2018 - Apr 20, 2018 at 05:57 PM
 Blocked Profile - Apr 20, 2018 at 07:32 PM
I have to go in every 2 weeks to update a spreadsheet, based on whether the date in the row is current or in the past.
Is there a way to set it up so that once the date in the cell passes, that it doesn't need to be included in the formula?
or is that asking too much?
to simplify my question, i'm calculating how many vacation days employees have left in their "vacation banks". So once the vacation is paid out, i don't have to include it in the calculations.


2 responses

This is the problem. The date will roll, every day. So are you going to open the same spreadsheet every day? When does the sheet get refreshed, by who?

OK take a look at examples, and let us know if this model fits your needs!



Please, understand, as posted it won't work as expected. This is done by design. The intention is to teach how to make it work, not do the JOB!