Quote:
Originally Posted by rossjp
Yes but I must not be as sharp as I thought because I can't figure out exactly what to enter into the "Age" field as a formula to give me a person's age by subtracting the "DOB" field date from the CurrentDate" field.
|
As you'll see from Charles' reply and from the tutorial, it's a whole lot more complicated than that...
Quote:
Originally Posted by Charles Kenyon
This isn't rocket science but seems a bit like alchemy because of the complexities of the calendar as well as the assumptions built into Word and Windows. These fields do not work for dates before January 1, 1901.
|
But there are other fields in the tutorial that show how to work with dates before January 1, 1901 and can be adapted to do the required age calculations for starting dates going back millennia - which even Excel can't do - plus Excel can't calculate dates before January 1, 1900 and miscalculates dates before 1 March 1900 because it wrongly treats that year as a leap year.