Excel: formula to generate an order number based on date
 

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?

Excel: formula to generate an order number based on date
 

If your date is in A1, use this formula:

=TEXT(A1,"mmddyy")

This assumes only one order per day.

Hope this helps.

Pete

On Feb 23, 8:19 pm, Gina Hastings <Gina
wrote:
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?

Excel: formula to generate an order number based on date
 

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.

"Pete_UK" wrote:

If your date is in A1, use this formula:

=TEXT(A1,"mmddyy")

This assumes only one order per day.

Hope this helps.

Pete

On Feb 23, 8:19 pm, Gina Hastings <Gina
wrote:
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?