If a record has no value, enter 0 or NA. You can use VBA to accomplish the same thing using the code in Listing A. The End (xlDown) property refers to the last cell in the Invoice Date column.