Date Formats

  • Thread starter Thread starter Bob
  • Start date Start date
B

Bob

I have about 4000 dates in a spreadsheet, some of the dates are in the
'mm/dd/yyyy' format and have no problem with them; however, interspersed
throughout the file are 'yyyy' dates only that tend to default to an
erroneous 'mm/dd/yyy' format. i.e., 1825 may get translated as 01/20/1905.
How can I have the 'mm/dd/yyyy' and 'yyyy' dates in the same column?
I've tried text and custom but still have no relief --

SgtBob
 
Say the dates are in column A, In B1 enter:

=IF(A1<3000,DATE(A1,1,1),A1) and copy down. The format column B as the date
format of your choice.
 
Back
Top