Help on Excel formula to increase invoice number based on date change
Posted on 2013-01-08
I have an excel spreadsheet that I use for invoicing a client. I would like to create an "if then" formula so that when a date changes in one of the cells, the cell that contains the invoice number will increment by 1.
For example, my date is 01/01/2013 and my invoice number is 2013-001. What I would like to happen is that anytime the date changes, the invoice will automatically update, so if the next time I open this file and the date changes to 01/04/2013 then I would like the invoice number to automatically update to 2013-002, hopefully this makes sense, thank you.