1900

  1. R

    Help with macro for pre 1900 dates

    I'm working on my family history and therefore often have to deal with dates that are before 1900. I have found the microsoft Agefunc macro that I can use to calculate age in years but I would like to have ages displayed as Years, Months, Days. I can do that already for dates after 01/01/1900 by...
  2. Please_H

    Gregorian Period 100-1900 and Aging

    Dear All, Just like my previous inquiry i have a set of Data on the early Gregorian years starting from 100-1900. What is the best way to make the excel understand and format them under dd/mm/yyyyy and do an aging with =today() Thank you.
  3. K

    =today() returns date of 00/01/1900

    Hi everyone I'm using Excel 2003. I have a spreadsheet which contains an =today() function. When I view the spreadsheet it correctly displays today's date and updates each day as you'd expect. When my colleague opens the same spreadsheet on her machine, the today's date function is not...
  4. N

    1904 and 1900 date systems

    Hi all, I'm having trouble with the Date System. In the same spreadsheet, it seems I need the 1904 system for displaying negative time values, however, this date system corrupts other time values fetched on a PivotTable (using sum calculation), which work as expected using the 1900 system...
  5. L

    Chart date labels are 1900

    I am working with a line graph and cannot get the x-axis labels to correctly display the dates in a yyyy format. If I try in a line graph, they simply stay mm/dd/yyyy format, when I tried in a scatter plot, the dates were displayed, but all having the year 1900. It appears that the dates are...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top