Julian date escalation

[Rick Moore]

Is there any way in excel to enter values that reflect the
current julian date?? What I need to do is keep a running
total of the number of days that has elapsed between the
submission of a purchase order and and the product
delivery date.

 

[John Wilson]

Rick,

take a look here for some help and explanations:
http://www.cpearson.com/excel/jdates.htm

John

 

[Guest]

Thanks..I'll give it a shot...Rick

-----Original Message-----
Rick,

take a look here for some help and explanations:
http://www.cpearson.com/excel/jdates.htm

John




.

 

[Ron Rosenfeld]

Is there any way in excel to enter values that reflect the
current julian date?? What I need to do is keep a running
total of the number of days that has elapsed between the
submission of a purchase order and and the product
delivery date.

Are you required to use Julian Dates?

Because, for example, if you had the Purchase Order Submission date in A1, and
the product delivery date in B1, the formula =B1-A1 would give you the number
of days between the two.


--ron

 

[Ron Rosenfeld]

Thanks..that might be the easiest solution...Rick

You're welcome.

Don't forget to format the cell in which you have the formula as "General" or
"Number" with the required decimal places and/or commas. Otherwise Excel may
turn it into a date.




--ron