That is exactly what I,m looking for daddy. The work periods are a rotating
schedule that lasts 27 days. They overlap the end of the quarters, as well
as years. Example: work period 1 this calendar year began on 1/22/2006 and
ran thru 2/17/2006, and so on. This December, work perion 13 begins on
12/12/2006, and ends on 1/7/2007. I think that whomever it was that thought
this schedule up was trying to stick it to those that followed---he he he.
Thanks again.

"daddylonglegs" wrote:


So you want 5 to remain until a specific date and then what, return to
zero? then become 5 again on the last day of the next quarter?

Can you define the end of the next work period?


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=521401