Julian date escalation

  • Thread starter Thread starter Rick Moore
  • Start date Start date
R

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.
 
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.
Click to expand...

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
 
Thanks..that might be the easiest solution...Rick
Click to expand...

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
 
Back
Top