The reduction formula to use the second way ie. We can add the text values according to our preferences either by using the CONCATENATE function in excel or ampersand. In the example below you have the start of the range in Column A end of the range in Column B and the value to be evaluated in Column C.
Use the DATEDIF function when you want to calculate the difference between two dates.
In the second expression the value is compared to the larger of the two numbers determined by the MAX function. How to Use Date Formula in Excel. The result appears in cell E1. There we can search for anything we want.