how to change number to date

  • Thread starter Thread starter Happy One
  • Start date Start date
Probably the best is:

=date(mod(a1,10000),mod(int(a1/10000),2),day(int(a1/1000000)))

This will handle the case where you have two digit dates.

Regards
Fred
 
This worked for me with my USA date settings (mdy):
=--TEXT(A1,"00\/00\/0000")
and formatted as a date
 
Yes, it works.

Thank you,

Dave Peterson said:
This worked for me with my USA date settings (mdy):
=--TEXT(A1,"00\/00\/0000")
and formatted as a date
Click to expand...
 
You must log in or register to reply here.

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

vlookup with two data points. 3
A1-1 changes format to Aribic date format 8
Automatic Update for Date 4
How do I calculate calendar dates 3
Compare the value of one cell to 2 different cells 4
Count Dates 2
match help 2
WeekDay count between dates 13

Back
Top