Forum Discussion
Age Formula
Hi, I'm looking for some help / advice. I have a spreadsheet which hold details of patients I provide anaesthetic care for. Part of this information includes date of birth, and date of their ...
Deleted
Please click the Excel menu and select Preferences.
Select Calculation.
Is the 'Use 1904 date system' check box ticked? If so, Excel cannot handle dates before January of 1904.
Warning: if you clear the check box, all existing (valid) dates will change!
VMT Hans,
An instantaneous fix with a disappointing limitation, but I've learned something new tonight - so all good. I'll just manually enter the age in the affected cells!
Best wishes Rory
An instantaneous fix with a disappointing limitation, but I've learned something new tonight - so all good. I'll just manually enter the age in the affected cells!
Best wishes Rory