1. I am trying to create an invoice that will update its own date, How do I do that?
2. I am trying to create an invoice that will update its Invoice number without having to be changed, How do I do that?:confused: :confused:

Any help will be appreciated. Thanks

1) Update it when, and under what parameters? What would have been to start with? Why would it change?

2) Invoice # don't change as I understand them. They increment with each new invoice that is created. What is your scenario for wanting an invoice # to actually change?

Here is a web link to a couple of great ideas for dealing with Invoice Numbers:

McGimpsey & Associates : Excel : Sequential numbers (http://www.mcgimpsey.com/excel/udfs/sequentialnums.html)