Excel: formula to generate an order number based on date

G

Gina Hastings

I am trying to create an order form that will generate an order number based
on the date the order is written. I would like to have the number shown
without the slashes (/). Example: If the order is written on 2/23/07, I
would like the order number to be
022307.

Is this possible?
 
P

Pete_UK

If your date is in A1, use this formula:

=TEXT(A1,"mmddyy")

This assumes only one order per day.

Hope this helps.

Pete
 
J

Joel

You don't even need th eformula. Use in the Format Menu - Number - Custom.
enter new custom format mmddyy. It is equivalent to what Pete recommended.
the mmddyy in the formula says to use custom formating.
 
Top