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 procedure.

I’ve just tried to add a column to determine the patient’s age at time of their procedure using the formula =DATEDIF(C3,G3,”Y”) where C3 is DOB & G3 DOP.

This works fine until I have any patients aged 99 or older, when #VALUE! displays.

Thanks in anticipation, Rory

​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 procedure. I’ve just tried to add a column to determine the patient’s age at time of their procedure using the formula =DATEDIF(C3,G3,”Y”) where C3 is DOB & G3 DOP. This works fine until I have any patients aged 99 or older, when #VALUE! displays. Thanks in anticipation, Rory  Read More

​