dates on forms
 

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.

dates on forms
 

Roy,

If the same full date is in each one, just format the cells custom.
e.g.
Format = "d" (single or double digit day number displayed)
Format = "dd" (double digit day number displayed (with leading zero))
Format = "ddd" (abbreviated day displayed (Wed, Thu, etc.))
Format = "dddd" (full day displayed ("Wednesday, Thursday, etc.))

The same works for the month also.
Year is "yy" or "yyyy"

John

"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.

dates on forms
 

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.