Generating a Julian date, but only showing the last two number
Hi again Joel
Here's the fomula I put in now:
=TEXT(C160,)&TEXT(MOD(C160-DATEVALUE("1/1/"&TEXT(C160,"yy"))+1,100),"000")
What this returns when the reference cell is 6/22/09 is 073. All I want
returned is 73.
How do I drop the zero?
Thanks
Fred
|