Concatenating a unique # with same dates

[retserrof]

I have a problem with a function that I'm trying to do to concatenate a date and a number that is unique. I have a date row (row 3) that when populated I want to create an order # based on that date and the # of orders that day. It should look like this "40977-1"
Here is the calculation that I have inputted in the order # feild.
=IF(ISBLANK(B3),"",(B3&"-"&COUNTIF(B:B,B3)))
The problem is that this returns only the total # of orders on that day and I want it to count up and number each order after the dash as they are posted. Thanks.

[Fotis1991]

Hi

You have to combine the Text function with date, or else you receive the date, as a number.

[Pete_UK]

Try it like this:

=IF(B3="","",(B3&"-"&COUNTIF(B$3:B3,B3)))

As you copy this down the countif range increases on each row.

Hope this helps.

Pete

[retserrof]

That worked perfectly. Thanks for the help Pete.

[Pete_UK]

You're welcome - glad to be of help.

Please mark the thread as Solved (check the FAQs to find out how), and you can pass on thanks directly by clicking on the "star" icon in the bottom left corner of any post that has helped you.

Pete