I'm trying to use data validation with dates. What I want to validate is whether the entered date is between a date in cell B32 and if cell C13 is 1, then the end date can be 2 years from the date in cell B32, and if cell C13 is not one then the entered date can be 6 years from the date in cell B32.

I coded the end date in the data validation to be this:
=IF($C$13=1,$B$32+2192,$B$32+731)
but it doesn't seem to work when C13 is not 1. Does something seem wrong with this formula?

Thanks.