I  have a calculated column which display's the value based on the difference between today and requested date field.

=Today-[Requested Date]

This is working fine in SharePoint Standard View. But the same is not working with the datasheet view . The calculated column is showing as below

=#NAME?-[Requested Date].

Due to this i am not able to save the data. Can anyone please let me know how to solve this ?

• Edited by Midhun Murali Tuesday, April 29, 2014 11:41 AM

You're not actually able to use the Today function in a calculated column. There's a trick that you can do to make it work, but it's not a valid functionality. Also, keep in mind that when you use the Today trick in the calculated column, it only shows Today as of the last modified date.

Hi,

First I have used today() function to calculate difference between 2 days except working days. The list is not automatically updating. If we change the Start_Date, then it calculates and gives the value. Can you suggrest me why this happens?

You have metioned in your post that there is some tricks in using today() function. I have created seperate Today_Date column in my list. And Used the same column name in finding difference between 2 days. Here also the same problem exists.

The formula I used is, =IF(AND((WEEKDAY([Today Date],2))<(WEEKDAY([Release Date],2)),((WEEKDAY([Release Date],2))-(WEEKDAY([Today Date],2)))>1),(((DATEDIF([Release Date],[Today Date],"D")+1))-(FLOOR((DATEDIF([Release Date],[Today Date],"D")+1)/7,1)*2)-2),(((DATEDIF([Release Date],[Today Date],"D")+1))-(FLOOR((DATEDIF([Release Date],[Today Date],"D")+1)/7,1)*2)))

please suggest me how to get Difference between 2 date  values get automatically updated everytime, when i open the list.