< Go Back

Get date from day number

Generic formula   

=DATE(year,1,daynum)

Explanation 

Getting a specific date from day number or any nth day of any year is very easy and precise by using the DATE function.

The following example depicts a formula used in C5 to get a date from day number:

=DATE(2015,1,B5)

      Figure 1- Generic Formula to get a date from day number

How does this work?

  • This DATE functions in a very efficient way as it provides exact dates in the output, according to the separate values of a year, month and day provided in it.
  • Another best functionality of this function to get a date from day number is that it automatically corrects dates when the given months or days are “out of range”.

Example 1

For example, the DATE gives an output for April 9, 2016 with the following date figures:

=DATE(2016,1,100)

Explanation

No month has 100 days in it and same is the case with January, so the DATE goes ahead of 100 days from 1st January and results to get a date from day number.

Figure 2. Get date from day number

Example 2

=DATE(2000, 6, 456)

Explanation

Another example using the same generic formula make you to able to get a date from day number. The number of days is entered 456 and no month has too many days, so the DATE goes ahead from the first 1st January to the provided day and you get a date from day number.

Figure 3. A related example to get a date from day number

 

Our customers love us!
“The expert was absolutely amazing and stuck with me the whole way through. They were polite, patient, seemed to want to genuinely help me and provided a solution that I would never have managed otherwise. I could not be more thankful for their support and solution. Thank you!” - - Chris T, in California

Leave a Comment

avatar