Hi everyone, I'm trying to use =DATE(YEAR(Expiration Date);MONTH(Expiration Date);DAY(Expiration Date)-30) for a new column I am trying to create but when I submit it, I get "The formula contains a syntax error or is not supported. " Where am I going wrong? Thanks

Use commas, and wrap your referenced field in brackets... =DATE(YEAR([Expiration Date]),MONTH([Expiration Date]),DAY([Expiration Date])-30) - M - Michael Mukalian - 2010 MS MVP SharePoint Services - MCTS: MOSS 2007 Configuration - http://www.mukalian.com/blog

Thanks Michael. I'm learning :-)

We all are always learning :)- Michael Mukalian - 2010 MS MVP SharePoint Services - MCTS: MOSS 2007 Configuration - http://www.mukalian.com/blog