Forum Discussion

JohnMald's avatar
JohnMald
Copper Contributor
Oct 26, 2021

How to null date if blank

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

  • 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.

Resources