Restricting date entry relative to current date

Restricting date entry relative to current date

Post by YndhbHNoan » Wed, 11 Apr 2007 20:36:02


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.
 
 
 

Restricting date entry relative to current date

Post by JE McGimps » Wed, 11 Apr 2007 20:49:26

One way:

Data/Validation:

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

In article < XXXX@XXXXX.COM >,