View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JE McGimpsey JE McGimpsey is offline
external usenet poster
 
Posts: 4,624
Default Restricting date entry relative to current date

One way:

Data/Validation:

Allow: Custom
Formula: =(A1-TODAY())<=4

In article ,
bwalshjr wrote:

I need to limit a date entry to no greater than four days from the current
date. The only Excel data validation schemes call for restricting by
specific dates. This validation is inadequate for my purposes.