I would suggest that you use a user defined formula which takes the
start and end date and implements the complex logic that you require.


--
mrice
------------------------------------------------------------------------
mrice's Profile: http://www.excelforum.com/member.php...o&userid=10931
View this thread: http://www.excelforum.com/showthread...hreadid=532728