View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.misc
Roger Govier Roger Govier is offline
external usenet poster
 
Posts: 2,886
Default Data Validation for a date

Hi

Glad we got there in the end. Thanks for the feedback.

--
Regards

Roger Govier


"mgkaam" wrote in message
...
Thank you so much that worked perfectly!

"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,