Microsoft Excel provides a ton of functions to work with dates and times. Each function performs a simple operation and by combining several functions within one formula you can solve more complex and challenging tasks. In this post, we are going to learn how to find the date from the given day number in Excel. Let’s begin!! Get an official version of ** MS Excel** from the following link: https://www.microsoft.com/en-in/microsoft-365/excel
General Formula:
- Use the below formula to get the date from the given date in Excel.
=DATE(year,1,day_num)
Syntax Explanations:
- DATE – This function helps to combine three different values and returns them as a date. Read more on the DATE function.
- Year – It specified the year.
- Day_num – It represents the input range.
- Comma symbol (,) – It is a separator that helps to separate a list of 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 day number in Column B.
- Now we are going to extract the date from the given day number.
- Select any cell and type the above-given formula.
- Here we will specify the year as 2020.
- Finally, press ENTER to get the result out, if you need, drag the fill handle over range to apply the formula.
Verdict:
From this article, we have explained the easiest way to get the date from the given day number in Excel. Hope you like it. If you have any doubts regarding this topic or any other Excel/VBA related topic, ask in the comments section below.
Thank you so much for visiting *Geek Excel!! **If you want to learn more helpful formulas, check out Excel Formulas *!! **
Top comments (0)