Example 2: Combine SWITCH function with other functions
Supposing, you have a worksheet with a column of dates, now, you want to determine if a date is occurring today, yesterday or tomorrow. In this case, you can use the TODAY function to return the serial number of the current date, and DAYS to return the number of days between two dates.
Please apply the following formula, and all the matched values have been returned into the cell based on the date.
=SWITCH(DAYS(TODAY(),C2),0,"Today",1,"Yesterday",-1,"Tomorrow", "Out of Range")
Would you like to complete your daily work quickly and perfectly? Kutools for Excel brings 300 powerful advanced features (Combine workbooks, sum by color, split cell contents, convert date, and so on...) and save 80% time for you.
Designed for 1500 work scenarios, helps you solve 80% Excel problems.
Reduce thousands of keyboard and mouse clicks every day, relieve your tired eyes and hands.
Become an Excel expert in 3 minutes. No longer need to remember any painful formulas and VBA codes.
30-day unlimited free trial. 60-day money back guarantee. Free upgrade and support for 2 years.