W
waybomb
Hello
I need to build a sheet for our production people to use that generates a
code date from an entered date in another cell. In one customer's case, I
need to generate a Julian date, but they only use the last two numbers of the
Julian date. The formula I use for regular Julian date generation is :
=TEXT(C160,)&TEXT((C160-DATEVALUE("1/1/"&TEXT(C160,"yy"))+1),"000")
If I simply delete the first zero in the "000", I only get 2 digits up to
99, but at 100 all three digits are indicated.
Thank you in advance!
I need to build a sheet for our production people to use that generates a
code date from an entered date in another cell. In one customer's case, I
need to generate a Julian date, but they only use the last two numbers of the
Julian date. The formula I use for regular Julian date generation is :
=TEXT(C160,)&TEXT((C160-DATEVALUE("1/1/"&TEXT(C160,"yy"))+1),"000")
If I simply delete the first zero in the "000", I only get 2 digits up to
99, but at 100 all three digits are indicated.
Thank you in advance!