Excel date conditions

Closed
Posts
1
Registration date
Friday April 20, 2018
Status
Member
Last seen
April 20, 2018
-
 Blocked Profile -
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.

Thanks!

2 replies

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!



Then


then

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!