No announcements

ProjDateDiff formula and Resume OData Question

Hi Erik, That formula works for me in PWA, the ony thing I had to do was to change the separator as I have different locale ...
| 5 Replies | 1152 Views | Created by Erik van Hurck - Friday, April 17, 2015 8:46 AM | Last reply by Erik van Hurck - Friday, April 17, 2015 9:50 AM

Help with ProjDateDiff()

ProjDateDiff("1/10/13",DatePart("M",[Finish]) & "/" & DatePart("d",[Finish]) & "/" & ...
| 6 Replies | 7351 Views | Created by Mrcvn - Tuesday, November 13, 2012 6:30 PM | Last reply by Mrcvn - Tuesday, November 13, 2012 9:23 PM

Need help with ProjDateDiff function

Hi, Would like to add a small detail. ProjDateDiff indeed by nature produces a duration which is expressezd from start to Finish generally not the reverse. the ...
| 6 Replies | 29864 Views | Created by Betty in NJ - Monday, April 11, 2011 6:50 PM | Last reply by Barbara Henhapl - Monday, April 11, 2011 7:46 PM

Project Server 2010 - Date Difference formula issues - Datediff or ProjDateDiff

been fruitless, and the reply to the question above has done nothing but further confuse me... Is it possible to write a formula that will do what I've described ...
| 3 Replies | 18391 Views | Created by Collin Quiring - Wednesday, March 30, 2011 6:36 PM | Last reply by Daren (DJ) Johnson - Friday, May 27, 2011 6:24 PM

Two Questions: 1) Use of ProjDateDiff formula and 2) Set baseline to earlier date

Hi, 1) Use of ProjDateDiff formula I tried to use the formula ProjDateDiff(date1, date2, calendar) but it returned #Error when ...
| 5 Replies | 3735 Views | Created by Bobby Wan - Tuesday, March 12, 2013 11:58 PM | Last reply by Dale Howard [MVP] - Wednesday, March 13, 2013 4:44 PM

ProjDateDiff Calculation Problem

Hello, i have touble with a formula on PWA successfully I have brought online this a Custom Field, entity task, type duration, ...
| 3 Replies | 1300 Views | Created by loffloff - Thursday, February 7, 2019 3:30 PM | Last reply by Olof Hansen - Friday, February 8, 2019 12:20 PM

Question on formulas

;9/30/18"), [cost],0) This generates another question.  I have to apply this formula each time I open the file. Otherwise I get #ERROR in the ...
| 7 Replies | 762 Views | Created by mesheedy - Friday, July 21, 2017 7:16 PM | Last reply by John - Project - Wednesday, July 26, 2017 12:58 PM

IF(AND formula question

Select the cell with the formula. Press F2 to edit it but don't change anything. Press Ctrl+Shift+Enter to turn the formula into an array ...
| 3 Replies | 1663 Views | Created by Dustin Shepard - Wednesday, January 16, 2013 6:36 AM | Last reply by Jaynet Zhang - Thursday, January 17, 2013 6:03 AM

OData Data Feed Question

Hi LadyTester, The Netflix OData feed was retired in 2013 (April) so it doesn't look like you're doing anything wrong (
| 1 Replies | 1138 Views | Created by LadyTester - Wednesday, April 23, 2014 10:34 PM | Last reply by Michael Amadi - Thursday, April 24, 2014 5:27 AM

Formula Question

is your ISNA return FALSE then else part of if would be execute no need to write=FALSE try below formula if ISNA retun FALSE then 1 will be ...
| 3 Replies | 824 Views | Created by Bob Cee - Thursday, January 30, 2014 1:14 PM | Last reply by Bob Cee - Friday, January 31, 2014 11:34 AM

Formula Question

Another quick question. I have formatted a negative number to show as a positive with 2 decimal places. However I want to show it in the Accounting style. Any suggestions what to put in to ...
| 4 Replies | 735 Views | Created by VHaig - Tuesday, January 21, 2014 4:23 PM | Last reply by VHaig - Wednesday, January 22, 2014 4:57 PM

formula question

Hi Manoj   Is this the only way. one of my formulas may have to have upto 100 ...
| 4 Replies | 4774 Views | Created by strictlydata - Friday, April 20, 2007 10:12 AM | Last reply by strictlydata - Friday, April 20, 2007 10:59 AM

Excel Formula Questions

I used to go to the Microsoft Comunity to get answers to my excel formula questions and it was great.  Apparently it isn't working anymore.  Can anyone tell me, as a ...
| 2 Replies | 6691 Views | Created by Bojangels - Tuesday, July 6, 2010 3:50 PM | Last reply by Bessie Zhao - Thursday, July 8, 2010 6:56 AM

Formula Question: ISNUMBER and SEARCH

Good afternoon, I had a question I was hoping someone could help with. I have this simple formula: ...
| 2 Replies | 518 Views | Created by pete6256 - Tuesday, June 21, 2016 4:42 PM | Last reply by Emi Zhang - Tuesday, June 28, 2016 9:28 AM

I'm trying to do the example here but I can't seem to get it to work with the Advanced Formula. Here's the page,
| 3 Replies | 753 Views | Created by ResidentX10 - Monday, July 27, 2015 10:06 AM | Last reply by ResidentX10 - Monday, July 27, 2015 11:08 AM

Sharepoint, Formula question

Hi, I just recently started using SharePoint at my company and had a question regarding changing a current column with date values into a ...
| 3 Replies | 316 Views | Created by JDeM222 - Thursday, September 27, 2018 7:23 PM | Last reply by Allen Bai - Thursday, October 4, 2018 2:01 AM

Excel Formula Question

Is it possible to include the color of a cell as a variable in a vertical lookup formula... i.e. If i have an orange filled '1' in cell A1 and a black filled '1' in cell A ...
| 0 Replies | 4419 Views | Created by texasqb - Wednesday, August 11, 2010 6:43 PM

Formula question INDEX & SUM

Hello, I had a question I was hoping someone could help with. I have a list of dates in column I, and I have bunch of text in each cell in column BA and ...
| 2 Replies | 359 Views | Created by pete6256 - Thursday, January 26, 2017 7:09 PM | Last reply by Deepak Saradkumar Panchal - Friday, January 27, 2017 1:31 AM