MrExcel Publishing
Your One Stop for Excel Tips & Solutions

years 1900 Vs 2000

Posted by LAURA on December 23, 2001 4:15 PM

In one column I need dates from last century like 07/12/01 (year 1901!)... but in the next I need current year dates like 07/12/01 (year 2001).

I have some formulas like -calculate age-...

How can I format "yy" the columns to work with 1900 or 2000 as needed in the same worksheet?

Thank you, amigos!

Merry Christmas!

Posted by Aladin Akyurek on December 24, 2001 1:07 AM

Laura --

If you're on a Mac, switch to the 1900 date system via Preferences.

Use custom format mm/dd/yyyy for the cells with dates.