=IF(F17,"1",DATE(YEAR(B17),MONTH(B17)+12,DAY(B17))
From your sample formula above,
believe you probably meant to do something like this
=IF(F17=1,DATE(YEAR(B17),MONTH(B17)+12,DAY(B17)),I F(F17=2, ...,
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:18,300 Files:361 Subscribers:57
xdemechanik
---