Happy to provide an example if you can clarify what exactly you're after : Thanks, Thom Hi Thomh or any other experts, I would like to be able to calculate an age rounded down to years only that is the difference between a particular date the date a patient was referred and their birthdate so that I end up with the age they were when they were referred by their GP | : Hi, how would I incorportate a text field form into this formula DOB bookmark referencing the DOB in this formula into a MSWord 2010 document? I've also tried creating a table in MSWord with 2 cells DOB in A1 and formula in A2 and I get a syntax error |
---|---|
In this case the functions are looking for dates so Excel may well have converted your dates into text format? So I want to subtract 1 from the other |
For Example In May I know Joe is 10 Years, 5 Month but he is only achieving as child of 8 Years, 10 Month.
30So I have an answer of how many Year, Month he is behind | The date of birth is in field C2 and the referral date is in field D2 |
---|---|
Hi Kassem, Value means that the Cells your Function refers to are not in the correct format for the Formula you are using i | I have created an Excel spreadsheet |
Thank you, David Hi Carrie, That's difficult because it may well be a year out without the EXACT age 81.
1It looks as though A13 is blank, thus it's counting the difference between today and the start of Excel's Calendar What it would consider as date 0 | The trouble is, Excel can sometimes see something as a different format to that which you see |
---|---|
then you can use any of the above functions | VALUE errors tend to mean that you're using referencing cells that don't contain data in the format the function expects |
Hi all - Need a bit of help.
23