Yes, to make sense WORKDAY needs a date entered with delimiters like
02/01/06 for Feb 2006 using US settings
or it needs the conversion whatever that might be depending on how you enter
"dates"
Note that it is always better to enter dates that excel can recognize
instead of enter pseudo dates that one has to convert to excel dates

--
Regards,

Peo Sjoblom

Portland, Oregon




"travelersway" <travelersway.22x7vb_1139419202.7497@excelforum-nospam.com>
wrote in message
news:travelersway.22x7vb_1139419202.7497@excelforum-nospam.com...
>
> TAYLORM,
>
> I followed your suggestion. I now receive the same day but an extended
> year: calculated date of 2/15/*20 *.
>
> I am using a custom format for the date; xx"/"xx"/"xx will this affect
> the results?
>
> Thank you for your help.
>
> TRAVELERSWAY.
>
>
> --
> travelersway
> ------------------------------------------------------------------------
> travelersway's Profile:
> http://www.excelforum.com/member.php...o&userid=17623
> View this thread: http://www.excelforum.com/showthread...hreadid=510032
>