Hi
I'm trying to find a formula to work out someones Age, based on 2 dates - dob and date case opened. I've found a number of options but they all seem to have a limitation, so want to check if there are any straight forward solutions. The formula needs to work out ages that include children less than 1 years old by returning a zero, and generaly round down.
I also need to find a formula that does not return a zero (or value 110) when a row is blank (i.e. does not have dob and case opened dates entered) or return an error message such as #value. This is because I have a summary page which summarises numbers of people between age bands and these results stop this from happening. I can manage a returned value of 110 as I can alter the adding up formula (e.g. count ages between 50 and 99, instead of ages >50), but I cannot manage the other results. However, I would rather not have to change the adding up formula at all, unless I really have to.
Thank you in advance for any help offered.
Nick
I'm trying to find a formula to work out someones Age, based on 2 dates - dob and date case opened. I've found a number of options but they all seem to have a limitation, so want to check if there are any straight forward solutions. The formula needs to work out ages that include children less than 1 years old by returning a zero, and generaly round down.
I also need to find a formula that does not return a zero (or value 110) when a row is blank (i.e. does not have dob and case opened dates entered) or return an error message such as #value. This is because I have a summary page which summarises numbers of people between age bands and these results stop this from happening. I can manage a returned value of 110 as I can alter the adding up formula (e.g. count ages between 50 and 99, instead of ages >50), but I cannot manage the other results. However, I would rather not have to change the adding up formula at all, unless I really have to.
Thank you in advance for any help offered.
Nick