One simple way round the problem of date recognition is to put your
start and end dates in cells and reference the cells in the formula.
This has the added benefit of making it very quick and easy to
calculate over any chosen date period.


--
Alex Delamain
------------------------------------------------------------------------
Alex Delamain's Profile: http://www.excelforum.com/member.php...o&userid=11273
View this thread: http://www.excelforum.com/showthread...hreadid=380469