Excel: formula to generate an order number based on date

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Gina Hastings - 23 Feb 2007 20:19 GMT

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?

Reply to this Message

Pete_UK - 23 Feb 2007 20:27 GMT

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
Hasti...@discussions.microsoft.com> 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
[quoted text clipped - 3 lines]
>
> Is this possible?

Reply to this Message

Joel - 23 Feb 2007 20:41 GMT

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.

> If your date is in A1, use this formula:
>
[quoted text clipped - 15 lines]
> >
> > Is this possible?

Reply to this Message