While working with date-based data, you often get the need to count down the remaining days from one date to another date. In this article, we are going to see how to calculate the number of days before a certain date in Excel. Let’s step into this article!! Get an official version of ** MS Excel** from the following link: https://www.microsoft.com/en-in/microsoft-365/excel
Generic Formula:
- To get the days before a given date in Excel, you can use the below formula.
For Today =date-TODAY()
Without Today Function = date1 – date 2
With Text ** =”Just “& date 1- date 2 &” days left!”**
Syntax Explanations:
- TODAY – This function helps you to get the current date on your workbook. Read more on the TODAY function.
- Date – It represents the input range from your worksheet.
- Minus Operator (-) – This symbol will help to subtract any two values.
- Parenthesis () – The main purpose of this symbol is to group the elements.
Practical Example:
Let’s consider the below example image.
- First, we will enter the input values in Column B and Column C.
- Here we need to calculate the number of days before the given date.
- Select any cell and type the above-given formula based on your criteria.
- Finally, press ENTER to get the result out.
Verdict:
Hope you like this article on how to calculate the number of days before a certain date** in Excel . Let me know if you have any ** doubts regarding this article or any other Excel/VBA topic.
Thank you so much for visiting *Geek Excel!! **If you want to learn more helpful formulas, check out Excel Formulas *!! **
Top comments (0)