Validating dates in a cell

[BrianG]

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

 

[merjet]

Why do you say data validation at the cell level won't work? The
following does for me.

Allow: Date
Data: between
Start date: =TODAY()
End date: =TODAY()+30

Hth,
Merjet

 

[BrianG]

The worksheet is perpetual so I assumed that dates entered this month
would become invalid next month. Now that I think about it, the
validation only occurs at the time of entry. Would this mean that
cell level validation would only become a problem if someone went back
to an old date and tried to edit it to a value that was outside the
validation range?

 

[merjet]

Would this mean that cell level validation would only become a

problem if someone went back to an old date and tried to edit it
to a value that was outside the validation range?

Yes.

Merjet