i have been wondering and what i need is a calculated column of type date that does the above comparation
i have written the following: =IF(Expires=1/1/2013,Expiration,Expires) i want that if expires=1/1/2013 have "Expiration" and if "Expire" isnt equal to 1/1/2013 then have "Expires"