I tried that, and ended up only getting the year and day format, no
hours/minutes, etc. Do you know if there is something missing from the
original function that was listed on the website? I'm not sure if using that
will allow the return to be anything more than just the year and day.

Thanks for your reply!

"dlw" wrote:

if you format a column date and time, then enter, say 01/06/08 10:30 AM, then
do the VALUE of that cell, you will get a decimal number that represents the
date and time. That could be your reference number.

"Steve C" wrote:

I am trying to create a spreadsheet to log some drawings that are done. I
would also like to use the julian date as a reference number. I have tried to
use the function found here, http://www.cpearson.com/excel/jdates.htm, but
that doesn't give me enough detail. Since I need multiple reference numbers
during the day, that function, which only gives me the year and the day,
limits my numbering scheme.

Can anyone help?

Thanks in advance!