Custom Date Format

  • Thread starter Thread starter Peter
  • Start date Start date
P

Peter

I want to format a series of cells with a custom date format that is
similar to mm/dd/yy but I want the year to always be 2003. I tried
creating a custom format mm/dd/03 but Excel didn't accept that. What's the
best way to do this?

Peter
 
You may want to make sure that the date is really in 2003 by using a helper
cell:

=date(2003,month(a1),day(a1))

with the real date in A1.

(it'll work for most dates--Feb 29 may cause you a problem.)
 
Back
Top