Custom Dates (VBA)

  • Thread starter Thread starter Bill Agee
  • Start date Start date
B

Bill Agee

I am trying to convert a date, 4/10/2004, to just Apr 04.

Is there a way to do this with the Format command?

I tried

mydate=Format(mm/dd/yyyy,"mmm yy")

but this doesn't work.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA in Excel 2007 date formatting 2
Date format. 1
Vba Date$ 1
Date formatting 1
how to put mydate into activecell as dd/mm/yyyy excel 2007 vb 3
VBA in Excel 2007, NumberFormat 1
Display date and time 4
Email to include a saved signature from outlook. 1

Back
Top