*Figure 1. Excel DATA VALIDATION Using the TODAY and AND Functions.*

Let’s assume that we have to generate a DATA VALIDATION using Excel’s TODAY and AND Functions to permit entries of dates occurring within the next 30 days, we must utilize a custom formula syntax based on the AND and TODAY Functions in Excel.

**Formula Syntax**

**=AND(logical1,[logical2], …)**

This formula syntax returns as a result TRUE or FALSE. Which simply means that formula will return FALSE if all conditions in the formula are FALSE, and TRUE when all conditions in the formula are TRUE.

**How to use Excel DATA VALIDATION Using the TODAY and AND Functions.**

Let’s say we have to create a data entry validation for dates exceeding 30 days from today in Excel,, we are going to get this done by following 3 simple steps;

- In our worksheet example below, we have a collection of dates scheduled for interviews;

* Figure 2. Excel DATA VALIDATION Using the TODAY and AND Functions.*

Our purpose here is to flag any date entries that occur after a period of 30 days from the present date.

- The DATA VALIDATION formula that we will enter into cell C2 of our worksheet example is as follows;

**=AND(B2>TODAY(),B2<=TODAY()+30)**

* Figure 3. Excel DATA VALIDATION Using the TODAY and AND Functions.*

Excel returned the result of the Data Validation as TRUE because the date is within the 30 day period (assume that today is 27th of January 2019)

- Copy and paste the modified version of the Data Validation formula in cell C2 above, down into the other cells in the RESULT column for the next results.

* Figure 4. Excel DATA VALIDATION Using the TODAY and AND Functions.*

We can use the Excel AND function when we want more than one or both conditions to be met.

*Figure 5. Final Result.*

**Instant Connection to an Expert through our Excelchat Service:**

Our live Excelchat Service is here for you. We have Excel Experts available 24/7 to answer any Excel questions you may have. Guaranteed connection within 30 seconds and a customized solution for you within 20 minutes.

## Leave a Comment