Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Hi there, I am trying to write a fo

Status
Not open for further replies.
Remmylek

Remmylek

IS-IT--Management
Mar 2, 2021
1
0
0
GB
Hi there, I am trying to write a formula in MS 2016 to show a variance

I added Date1 and renamed it. I want a text field with a formula to compare the baseline finish against the date in Date1. But each time I set the formula it assumes the N/A in Date1 is < than the baseline date and says there is a date date change. but I don't want the formula to pick up the N/A. Can someone please help.

Thank you
 
Status
Not open for further replies.

Similar threads

Jackson920
  • Locked
  • Question
how to fix a corrupted schedule in Project 2013 (Standard)
Replies
0
Views
54
Jackson920
Jackson920
jairoriele
  • Locked
  • Question
Cálculo do IDP (IDA)
Replies
1
Views
67
SkipVought
S
0sprey
  • Locked
  • Question
Sources of actual MS Project files to use a example
Replies
6
Views
91
0sprey
0sprey
0sprey
  • Locked
  • Question
MSP 2010 - ResourcePool.mpp &gt; &quot;There is a problem with the Calendar name.&quot; 1
Replies
3
Views
80
JulieInMaine
JulieInMaine
hermanlaksko
  • Locked
  • Question
Return values from Dropdown in ribbon
Replies
0
Views
56
hermanlaksko
hermanlaksko

Part and Inventory Search

Sponsor

Back
Top