Forum Discussion
DabriFo
Nov 02, 2023Copper Contributor
Status Date
I am batteling with the following formula in MS Project: IIf([Status Date]=#2023/01/31#,[Actual Cost],0) Can somebody please tell my why it keeps on returning 0 even if the Status Date is set as 202...
- Aug 08, 2024
Have the data been imported/copied from a source outside Excel? The blank-looking cells are not really blank.
One workaround is to use
=COUNTIF(Table3_1[@[Text Between Delimiters.5]:[Text Between Delimiters.11]], "> ")
Another is to select the entire table except for the last column, then activate the Visual Basic Editor (Alt+F11), activate the Immediate window (Ctrl+G), type
Selection.Value = Selection.Value
and press Enter. The COUNTA formula will then work correctly.
ismet_kocaman
Nov 02, 2023Brass Contributor
Time part is missing in the date literal #2023/01/31#. Either exclude the times in the comparison expression or add them to both sides. That is, either use Int( [Status Date] ) = #2023/01/31# or [Status Date] = #2023/01/31 17:00# assuming that the status time is 17:00 based on the default end time.
DabriFo
Nov 11, 2023Copper Contributor
Thanks - problem solved.
- ismet_kocamanNov 11, 2023Brass Contributor
You're welcome. And thanks for the feedback.