Discussion Locked

excel programming

0 helpful
4 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

can someone tell me how i can change this julian date output to be in this format instead..here is the formula i use the output it gives and the order i would prefer....
=TEXT(C5,"yy")&TEXT((C5-DATEVALUE("1/1/"&TEXT(C5,"yy"))+1),"000") gives output Ex: 02058 would prefer it to give 0582...we do not use 02 for year we use 2 and we do not want year first we want it last...any suggestions?
thanks

4 replies

by dklippert

BTW using your formula your layout would be:

=TEXT(A1-DATE(YEAR(A1),1,0),"000")&TEXT(RIGHT(YEAR(A1),2),"##")

This discussion is closed to new replies.