I not usre what you are asking but I think you want to use a mudular 100
function in your code

=Mod(123,100)


so
from
C160-DATEVALUE("1/1/"&TEXT(C160,"yy"))+1

to
mod(C160-DATEVALUE("1/1/"&TEXT(C160,"yy"))+1,100)

"waybomb" wrote:

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!