Date

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm lazy and when I type the date in a cell I would like to type 080807 and
have it dispalyed as 08/08/07. Any Ideas??
 
You can use a helper cell. If you enter 00807 in A1 as text, then in another
cell enter:

=DATE(RIGHT(A1)+2000,LEFT(A1,2),MID(A1,3,2))
 
.... or =DATE(RIGHT(A1,2)+2000,MID(A1,3,2),LEFT(A1,2)), depending on how you
want your dates to be interpreted.
 
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

changing date formats 5
How to set formula for poping up the date of next Wednesday.... 2
Allocate an income payment over a date range (tax years) 7
How to determine the value? 1
Min if Function? 4
Create a chart of totals over time? 1
Workday Formula to include date 0
Lookup between two dates 3

Back
Top