USE THE IF FUNCTION TO CHECK WHETHER A DATE IS IN THE PAST OR FUTURE USING MICROSOFT EXCEL

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->.

USE THE IF FUNCTION TO CHECK WHETHER A DATE IS IN THE PAST OR FUTURE USING MICROSOFT EXCEL

Microsoft Excel Tutorials, MS Excel Tutorials, Logical Functions in Excel, IF function in MS Excel, TODAY() Function in Excel, Use the IF and TODAY function to check whether a date is in the past or future using MS Excel, Video Tutorials of Microsoft Excel, Advanced Functions in Excel, Formulas in Excel, Using Macros & VBA Codes in Excel