Excel: formula to generate an order number based on date

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
If your date is in A1, use this formula:

=TEXT(A1,"mmddyy")

This assumes only one order per day.

Hope this helps.

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

random number generator 6
Show date based on conditions 0
Basing math on duplicate entries in a formula 1
How to find the correct end date 3
Lookup MIN Date 6
Lookup returning wrong results 0
using a formula to create an ordered purchase order 5
Need a formula to create an order number 5

Back
Top