How To Use TODAY Function In SharePoint Calculated Field

How To Use TODAY Function In SharePoint Calculated Field?

SharePoint throws an error when you try to use functions like "Today" and "Me" in Calculated Field.

Calculated columns cannot contain volatile functions like Today and Me.

To overcome this issue follow below steps:

1. Create new column named "Today" with any datatype(Single Line Text)

2. Now Create calculated field with TODAY column in formula

Example: =DATEDIF([Start Date], [Today], "d")

3. If you check the columns values now, it will show something like #num!. Ignore it.

4. Now delete column "Today". That's it and check values. It will show corrects output that is date difference between Start Date and Today.