Convert Date to MMYY

  • Thread starter Thread starter Guest
  • Start date Start date
If you want a string with that, then use =TEXT(A1,"mmyy")

--

HTH

RP
(remove nothere from the email address if mailing direct)
 

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

Sumif date range 2
Convert Date 3
Getting Month Name 1
Best Tool to Convert PST to PDF 1
Sumproduct with nested if statement 5
Select Case 6
How can you format a date/time datatype to read month and year? 1
Validation of Field 3

Back
Top