Validating dates in excel patel foundry networks options backdating
Next, it evaluates if the date in C3 is less than or equal to the date 30 days from today, as given by the formula TODAY() 30.
Excel stores dates as serial numbers, making it possible to perform calculations involving dates.
This step by step tutorial will assist all levels of Excel users in allowing only dates in a specific year. Otherwise, Data Validation fails and the value is restricted.
See below table that is filled up with dates in column C in the year 2019, and allowed by Data Validation.
In this example, we refer to the date today as January 29, 2019, while the date 30 days from now would be February 28, 2019.
First, it evaluates if the date in C3 is greater than the date today.
As you can see, this cell also contains the correct formula.
In other words, Mondays, Tuesdays, Wednesdays, Thursdays and Fridays are allowed. Because we selected the range A2: A4 before we clicked on Data Validation, Excel automatically copies the formula to the other cells. To check this, select cell A3 and click Data Validation.
Note: Excel has several built-in data validation rules for dates.
This page explains how to create a your own validation rule based on a custom formula in case you want or need more control and flexibility.