I have an excel file used to track specific personal information for a group
of people who work for me. I have a column for date of birth and in a
separate column, I would like to calculate a point value based on the
following:
DOB is younger than 05/01/1986 assign points value of 150
DOB is between 04/30/86 and 05/01/84 assign points value of 100
DOB is between 04/30/84 and 05/01/82 assign points value of 50
DOB is older than 04/30/82 assign points value of 0.

I found the IF formula, but I've only got it to work with one of the above,
not all of them. I've tried the OR formula too, but haven't been able to get
it to work correctly.
Any suggestions? I was hoping to get this into place and then be able to
change the dates in the formulas as time passes.
Thanks in advance for any assistance.