| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Restricting date entry relative to current date
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I want any date 90 days or older from current date change color | Excel Worksheet Functions | |||
| Make date change in excel to current date when opening daily? | Excel Discussion (Misc queries) | |||
| formula to calculate age using birth date and current date | Excel Worksheet Functions | |||
| How do I enter a date range ie -7 from current date in MS QUERY | Excel Discussion (Misc queries) | |||
| Calculating days between current date and a date in future NETWORKDAYS() function | Excel Worksheet Functions | |||
Linear Mode
