returning a value from a date range

[quickbrwnfox]

Hi there,

I have a simple problem using IF statement, basically I want cell A2 to return the PRES AGE once i input a date of birth on cell A1.

Here are the scenarios:

1. Date of birth is before 1/07/1960, then PRES AGE is = 55
2. Date of birth is beetween 01/07/1960 to 30/06/1961, then PRES AGE is = 56
3. Date of birth is beetween 01/07/1961 to 30/06/1962, then PRES AGE is = 57
4. Date of birth is beetween 01/07/1962 to 30/06/1963, then PRES AGE is = 58
5. Date of birth is beetween 01/07/1963 to 30/06/1964, then PRES AGE is = 59
6. Date of birth is after 30/06/1964, then PRES AGE is = 60

Your help would really be appreciated.Thanks.- from a Newbie