That got me closer but the draw back here is that for those members after jan. Example is, join date jan 5, 2002. Using DateSerial(Year(Date()),Month([Membership]),Day([Membership])))would show me the next due date of jan 2004 which is incorrect. It should be jan 2005. It works perfect for...