I'm trying to find a way to add the accrued vacation time to a cell to
then be added for a running total:
=IF(ISNA(MATCH(F12,Vacation,0)),0,5)
This works great, except I need a way for the accrued 5 days to remain
in the cell until the end of the work period, then reset to zero. This
adds the 5 there, but only for the actual date. The (F12) is a cell
reference for TODAY(), and I also can easily reference the actual dates
that are in the work period.
Any ideas out there would be greatly appreciated. Thanks.....Maxx
then be added for a running total:
=IF(ISNA(MATCH(F12,Vacation,0)),0,5)
This works great, except I need a way for the accrued 5 days to remain
in the cell until the end of the work period, then reset to zero. This
adds the 5 there, but only for the actual date. The (F12) is a cell
reference for TODAY(), and I also can easily reference the actual dates
that are in the work period.
Any ideas out there would be greatly appreciated. Thanks.....Maxx
文章標籤
全站熱搜
