Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Number of day - date function
Hi NG,
Is there a function in Excel that returns the date when given the number of the day in the year (i.e. 1-365)? All help is greatly appreciated. Thanks in advance! Best, M.L. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Number of day - date function
In an available cell (say A1), put the date 31/12/05, then next to the cell where you enter the number for the days into a year (say B2) enter =A2+A1 -- Gary Brown ------------------------------------------------------------------------ Gary Brown's Profile: http://www.excelforum.com/member.php...o&userid=17084 View this thread: http://www.excelforum.com/showthread...hreadid=502524 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Number of day - date function
You can just add the number of days to the last day of the previous year.
Example: ="12/31/2005" + I4 would yield the date in 2006 according to the value in I4 (when formatted as a date, of course). Will " wrote: Hi NG, Is there a function in Excel that returns the date when given the number of the day in the year (i.e. 1-365)? All help is greatly appreciated. Thanks in advance! Best, M.L. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Number of day - date function
Assumint numbers are in Column A, and you want dates for THIS year, put this
in B1 ad copy down.......... =DATEVALUE(12&"/"&31&"/"&YEAR(TODAY()))-365+A1 Vaya con Dios, Chuck, CABGx3 " wrote: Hi NG, Is there a function in Excel that returns the date when given the number of the day in the year (i.e. 1-365)? All help is greatly appreciated. Thanks in advance! Best, M.L. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Number of day - date function
Thanks to all! I appreciate it.
Best, M.L. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Number value based on date function | Excel Worksheet Functions | |||
Using the Indirect function with a sheet number instead of a sheet name | Excel Worksheet Functions | |||
Date Function | Excel Discussion (Misc queries) | |||
Number range function | Excel Discussion (Misc queries) | |||
Date & Time | New Users to Excel |