Choose the desired unit. You can either put the dates directly in the formula or use cell reference. So to check whether a date is in between two mentioned dates we have the same application as the median formula.
Learn how to format a cell as a number or date.
Excel IF Function Test for specified. Between a future date and today. IF AND A2B1A2. Calculate the difference between two dates Difference in days.