Calculated columns: Using [Today] in a Sharepoint calculated column

Published on Author peter.stilgoe

When using [Today] in a formula / calculated column in SharePoint you get the following error:

“Calculated columns cannot contain volatile functions like Today and Me”

For SharePoint 2010 / SharePoint 2013 / SharePoint Online you can use the Today() function eg.



=IF(AND([Date Ordered]<Today()-5, OR([Purchase Status]=”SOLD”,[Purchase Status]=”NOT SOLD”,[Purchase Status]=”ITEM NEVER DELIVERED”,[Purchase Status]=”NO STOCK – NOT PROCESSED”)),”Yes”,”No”)