Microsoft Excel Functions & Formulas

Use the TODAY function to check for

future dates

In a worksheet, dates in column A have to be checked to see if they

are in the future. The actual date can be determined by using the

TODAY function and can be compared with the dates in the

worksheet using the IF function. If dates are in the future, the

result in column B should be Y; otherwise, it should be N.

4

To check for future dates:

1. In cell D1, type the formula =TODAY() to show the cur-

rent date.

2. Select cells B2:B10 and type the following formula:

=IF(A2<=TODAY(),"n","y").

3. Press <Ctrl+Enter>.

94

Chapter 4

Figure 4-3