SharePoint calculated column formula

I need the formula that calculates difference between two dates but only when date2 is present. So I know that I need =DATEDIF(date1, date2,"d") but I don't know how to check if the date2 is present. When there is no date2 it should say 'na'.
MisUszatekAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Rainer JeschorConnect With a Mentor Commented:
Hi,
this formula will work:
=IF(OR(LEN([Date1])=0,LEN([Date2])=0),"na",DATEDIF([Date1],[Date2],"d"))

Open in new window

HTH
Rainer
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.