Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- =TEXT([Column1],"yy")&TEXT(([Column1]-DATEVALUE("1/1/"& TEXT([Column1],"yy"))+1),"000")
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement