I’ve this problem:
I’d like to add a column in which I want to show the duration of tasks and summary tasks in calendar (solar) days. I’ve added a column, formatted as number, in which I’ve put this formula: “DateValue([Fine])-DateValue([Inizio])” (“fine” stands for end, “inizio” for start), but I get numbers with two decimal (17.38 days…?) for tasks, and I get 0 for summary tasks.
could anyone help me?
Gianluca Coppola – By solar days, I suppose you meant calendar days between start and finish. Insert a Number1 column and you can use DateDiff(). DateDiff(“d”,[Start],[Finish]) returns the number of calendar days between Start and Finish but this function will return a value one less that what is expected. For example, for Start = 1 Jan, Finish = 1 Jan, this function will return 0 but we expect 1. So, in the formula add 1 to the returned value. Let me know if this helps.