Results 1 to 2 of 2
2007-01-14, 11:44 #1
- Join Date
- Feb 2003
- Thanked 0 Times in 0 Posts
Incrementing Numbers and Text? (2004 for Mac v11.3.3)
I'm trying to create a relatively simple spreadsheet for my wife's graphic design business, so she can keep track of the projects she's working on, how many hours, how much she made, invoice dates, invoice numbers, etc. for each project. My wife is "excelphobic", so I'm trying to keep this as low maintenance and automatic as possible, so that all she's doing is inputting data.
I'm trying to create an invoice number that automatically increments by one, each time a project is complete. Here's the formula I've started with -
=IF(I2>0,"BPD-"&TEXT(H2,"YYYY")&"-000"&1,"") which would return, for example - BDP-2007-0001
I2 = Actual Hours of the project / H2 = the date the project ended.
So for the second project that ends, I'd like the invoice number to be BDP-2007-0002, and so on.
Also, if possible, once a new year starts, e.g. 2008, I'd like to be able to reset the automatically generated number back to 1, e.g. BDP-2008-0001.
Thanks for any help provided!
2007-01-14, 12:00 #2
- Join Date
- Mar 2002
- Thanked 30 Times in 30 Posts
Re: Incrementing Numbers and Text? (2004 for Mac v11.3.3)
See the attached sample workbook. The Aux column can be hidden if you wish.