Hi

Mark cells AM1:AM50.
DataValidationCustomFormula =A1-TODAY()=60
Select Error Alert tab and type in suitable message

--
Regards

Roger Govier


"mgkaam" wrote in message
...
Is there a way to actually put the formula in the Data
ValidationSettings
area for the 50 rows which are am1:am50. I would rather do it there
than in
a cell. I have tried it in there but I don't know what to put the
Data
Settings i.e. between, equal to, not equal too..... I know I am
asking for a
lot but this file is than saved as a .txt file and I don't want to add
any
more columns for just this formula.

Thanks again for the fast response

"Sara" wrote:

Hi,

IF columm A is the cell to enter date. Then enter this formula in
columm B,
next to the cell which you enter the date. Lets say if you you have
entered
date in cell A1, then enter this formula in cell B1.

=IF(A1-TODAY()=60,"ERROR","")

If the date minus today is more or equal to 60, then the words
'ERROR' will
appear in cell B1. After enter this formula, just drag down to
whichever row
required.

Hope it helps.
Sara


"mgkaam" wrote:

I have a column that people will enter any date in this format
01/01/07, I
need to validate that if this date is older than 60 days from
Today's date
than it will give me an error. What kind of formula would I need
to achieve
this? I have to do this for 50 rows in the same column.

Thanks,