Resetting data to zero when a specific date is reached

[Berean50]

Hi all,

I've attached an Excel doc that helps my manage vacation time for my employees. I've got tow issues with it. I've outlined the issues in the document itself. Essentially, I need to reset a column after a certain date has been reached and to ensure that a specific column takes into consideration two different vacation period.

Thanks

[tuph]

Here's a suggestion for column B:
To reset column B to 0 on 1st May, type the date 1/5/2015 into cell R1 then edit your formula like this:

Please Login or Register  to view this content.

[tuph]

Oops! wrong column - sorry. Simply apply the IF statement to columns D:G instead of column B.

Here's a suggestion for column B:
To reset column B to 0 on 1st May, type the date 1/5/2015 into cell R1 then edit your formula like this:

Please Login or Register  to view this content.

[tuph]

Once columns D:G are calculating correctly I think you shoud be able to simplify the formula in column R to

Please Login or Register  to view this content.