Hi all,

I have been using a Dated if function to return how many years, months and days have occurred between two dates. I am now trying to use an if function to tell me if this result is between two time periods. The formula however, is not working all the time.

So, I have grouped it into the following: -

less than 4 months = if(result<"0 years, 4 months, 0 days")
more than 4 months but less than 1 year = if(and(result >="0 years, 4 months, 0 days",result<"1 Years, 0 months, 0 days")
more than 1 year but less than 2 years = as above
more than 2 years but less than 5 years = as above
more than 5 years but less than 10 years = as above
more than 10 years = if(result>"10 years, 0 months, 0 days")

The formula is working on anything for less than 4 months, 4 months to 1 year, 1-2 years and 10 years plus but, anything between 2 and 10 years is coming back as 10+ years.

Any help would be appreciated, I am unable to upload an example file at the moment but, can do later on.