View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
mgkaam mgkaam is offline
external usenet poster
 
Posts: 6
Default Data Validation for a date

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,