MOSS Forum

Ask Question   UnAnswered
Home » Forum » MOSS       RSS Feeds

Calculated date field issue

  Asked By: Shauna    Date: Aug 19    Category: MOSS    Views: 1523

We are calculating two date fields. however one is a start date the other is a
stop date. Our issue is the stop date seldom have a value until the stop date
has arrived and entered. So until the stop date the column returns #NUM! How
can we suppress the value of #NUM!?

Formula is currently =DATEDIF([Nexavar start date],[Nexavar Stop Date],"d")



1 Answer Found

Answer #1    Answered By: Adya Deshmane     Answered On: Aug 19

Well we did figure out the needed string(s).

=IF(NOT(ISNUMBER([Nexavar start date])),"",IF(NOT(ISNUMBER([Nexavar Stop
Date])),"",DATEDIF([Nexavar start date],[Nexavar Stop Date],"d")))

This page helped greatly!


Didn't find what you were looking for? Find more on Calculated date field issue Or get search suggestion and latest updates.