Don't understand why you have a problem. The simple answer is to
put,in individual cells :-
=DAY(A1)
=MONTH(A1)
=YEAR(A1)
or some other date value instead of A1.

Regards
BrianB
===========================


"Roy Schultz" wrote in message ...
I am using excel to fill in and print delivery receipts for merchandise.
On one of the forms instead on one block for the date, there are three
seperate
ones for "Month", "Day", and "Year"
I am using the WORKDAY function as the merchandise usually is delivered the
day
after the form is printed.
Is there a way I can get Excel to display ONLY the Month, Day, and Year each
in it's own cell??
Changing the form is not an option as they are specified, and provided by
the vendor through whom the merchandise
is being billed.

Any help will be greatly appreciated.