Date Validation Rules to limit an input range

C

CMA

I would like to create a date validation rule as follows:

If the current date is within the first 10 calendar days of the month,
accept a date entry that falls between now and the first day of the previous
month.

If the current date is within day 11 and the end of the current month, allow
any date within the current month.

I'm hoping to avoid using VBA for this (I will if I must) but I'm wondering
if the Date Validation rules within the data table can allow this to happen
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Properties - Format, Input Mask, Validation Rule 5
Macro for Dates 5
Automatically sending multiple parts of text from one word doc to another - is possible. 0
Extra help on Nth Day of month 1
Date Validation - First 7 days of the month 6
Record Review Process 2
Help to Highlight Excel Row based on Weekly Date Range 2
Count number of records by date 2

Top