Date to 3 digits

[xoxo]

Hi, please someone help me with this obstacle.

On A1, I have the date in this format 8/6/11 and on B1 I like to have the month and day combined into 3 digits in this format 806. Is there a formula for B1 to list 806 from 8/6/11?

When the date gets to 8/16/11 B1 should have 816.
When the month is in two digit, I just want the second digit (12/1/11 = 201 on B1).

Appreciate any help!
xoxo

 

[VoG]

Try

=RIGHT(TEXT(A1,"m"),1)&TEXT(A1,"dd")

 

[Rick Rothstein]

Give this formula a try....

=RIGHT(TEXT(D3,"mdd"),3)

 

[xoxo]

Thank you very much VoG & Rick Rothstein! Where you guys learn this stuff. It's amazing!