I have a worksheet in which a transaction date is entered into cells
in column A. I need to validate that date when it is entered to
insure it is no earlier than Today() and no greater than Today()+30.
The worksheet is perpetual so data validation at the cell level won't
work. How can I validate the date at a macro level so that the cell
value doesn't become invalid 31 days in the future?

TIA

BrianG