Forum Discussion
Help with formula to work out age on arrival for paediatric A&E patients?
I am completing an audit in A&E. I am looking for a formula to work out age on arrival (to A&E) from DOB (D2) and arrival date (C2). As this is for paediatrics, the ages will range from 1 day up to 18 years. The formulas I have found online don't seem to work. For example I may need 4m 13days or just 28 days etc. Would really appreciate your help
1 Reply
If you are entering the data into an Excel Table that grows to include any further data you may append, you could use
= CONCAT( DATEDIF([@DOB], [@Arrival], {"y","ym","md"}) & {"y ","m ","d"})There are also dynamic array or traditional versions of the formula.
