Use the TODAY function to check for future dates - Date and Time Functions - Microsoft Excel Tutorials

Use the TODAY function to check for future dates using Microsoft Excel 

How 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 in Microsoft Excel and can be compared with the dates in the worksheet using the IF function of Microsoft Excel. If dates are in the future, the result in column B should be Y; otherwise, it should be N. 

To check for future dates:

1. In cell D1, type the formula =TODAY() to show the current date.
2. Select cells B2:B10 and type the following formula: =IF(A2<=TODAY(),"n","y").
3. Press <-Ctrl+Enter->.

Watch the Video Tutorial - https://www.youtube.com/watch?v=wpMBwxUArAI 

Use the IF function to check whether a date is in the past or future - Logical Functions - Microsoft Excel Tutorials

16.  Use the IF function to check whether a date is in the past or future

In this example we want to check whether a particular date is in the past or the future. To do so, the TODAY() function is used with IF to compare dates with the actual date and show its result.

To compare dates — variant A:

1. Select cell B2:B11 and type the following formula: =IF(NOT(A2>TODAY()),"past","future").
2. Press <-Ctrl+Enter->.

To compare dates — variant B:

1. Select cell B2:B11 and type the following formula: =IF(A2>=TODAY(),IF(A2=TODAY(),"Today",
"Future"),"Past").
2. Press <-Ctrl+Enter->.

Watch the Video Tutorial - https://www.youtube.com/watch?v=-VTFgE4pSvU

  Hope You Like This Tutorials - Give Comments