When I changed mine to a Custom format of xx"/"xx"/"xx as you said, it
displayed xx/xx/xx. So I'm not sure exactly what you're trying to do
there.
I have 2/15/2006 in cell A1, with a normal Date type format. In cell
B2 I have the following formula:
=WORKDAY(A1,10) to add 10 working days to 2/15/2006.
The result in cell B2 (with the same Date type format as cell A1) shows
3/1/2006.
--
taylorm
------------------------------------------------------------------------
taylorm's Profile:
http://www.excelforum.com/member.php...o&userid=28892
View this thread:
http://www.excelforum.com/showthread...hreadid=510032