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:
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”.
For example, the DATE gives an output for April 9, 2016 with the following date figures:
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
=DATE(2000, 6, 456)
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