Neil

Posts: n/a

Excel should support DAYOFYEAR(year,month,day) returns julian dat.

And the reverse function JULDATE. This is easier than writing the equation:
=DATE(2005,4,15)-DATE(2005,1,1)+1

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
I get a program error when I download an excel template	Ladybug	Excel Discussion (Misc queries)	3	March 4th 05 12:02 AM
html to excel	nellie	Excel Discussion (Misc queries)	4	February 8th 05 10:37 PM
Excel should support multiple monitors better (like Word does)	CoffeeAdict	Excel Worksheet Functions	5	February 8th 05 02:04 AM
Excel error - Startup (and Acrobat PDFMaker)	gxdata	Setting up and Configuration of Excel	0	February 4th 05 03:44 AM
Merge from Excel to Excel	dalstar	Excel Discussion (Misc queries)	3	January 30th 05 02:37 PM

All times are GMT +1. The time now is 03:00 AM.

About Us

"It's about Microsoft Excel"