Excel Function Bar
 

Is there a way to change mm/dd/yy in the function bar to show only mm/yy
using Date formats function or is there a way to write a custom app.

Excel Function Bar
 

I think The function bar gets it format from WIndows locals setting:
dateformat, you would need to change this.

DM Unseen