>>dRenewDate = GOMONTH(dExpireDate,12)
>
>As I replied to Fred, it returns Feb 28 and not March 1. Since there isn't a 29 next year, isn't suppose to return March 1?

No, because GOMONTH stays within the same month. There is no February 29, 2001, so it HAS TO return the last available day for that month, the 28th.