How to null date if blank

%3CLINGO-SUB%20id%3D%22lingo-sub-2888170%22%20slang%3D%22en-US%22%3EHow%20to%20null%20date%20if%20blank%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2888170%22%20slang%3D%22en-US%22%3EHello%2C%3CBR%20%2F%3E%3CBR%20%2F%3EI%20am%20trying%20to%20create%20a%20calculated%20column%20using%20the%20formula%20but%20want%20the%20calculated%20filed%20to%20be%20blank%20if%20the%20%E2%80%9CIC%E2%80%9D%20date%20is%20blank.%20Can%20someone%20help%20please%3CBR%20%2F%3E%3CBR%20%2F%3E%3D%5BEAS%5D-%5BIC%5D%3C%2FLINGO-BODY%3E
New Contributor
Hello,

I am trying to create a calculated column using the formula but want the calculated filed to be blank if the “IC” date is blank. Can someone help please

=[EAS]-[IC]
2 Replies
=if(isblank([IC]),"",[EAS]-[IC])

@JohnMald Try using below formula:

 

 

=IF(ISBLANK([IC]), "", [EAS] - [IC])

 

 

Note:

  1. Sometimes comma(,) does not work in formula (I am not sure but it is based on something language or regional settings on your site). So in that case use semicolon(;) instead of comma(,).

Official Documentations:

  1. Calculated Field Formulas
  2. IF function

Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.