Posted to microsoft.public.excel.misc

Posts: n/a

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.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Number value based on date function	Neil M	Excel Worksheet Functions	2	January 12th 06 12:57 AM
Using the Indirect function with a sheet number instead of a sheet name	JDB	Excel Worksheet Functions	5	December 31st 05 03:03 PM
Date Function	LisaS	Excel Discussion (Misc queries)	1	July 27th 05 08:36 PM
Number range function	Sonya T	Excel Discussion (Misc queries)	2	July 19th 05 01:19 AM
Date & Time	mully	New Users to Excel	4	May 23rd 05 11:56 AM

All times are GMT +1. The time now is 08:01 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us