dates on forms

  • Thread starter Thread starter Roy Schultz
  • Start date Start date
R

Roy Schultz

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.
 
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
 
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
===========================
 
Back
Top