View original (French)

EXCEL Calculate if cell is not empty

Solved
TITI66MATH Posted messages 5 Status Member -  
 xx -
Hello,

I would like to subtract two dates only if the cells are not empty.
If one cell is empty, I would like to get an empty cell as a result.

The formula I am using is =NETWORKDAYS(A1,A2)

For example, in A1 I have 10/03/13 and in A2 I have 10/05/13, in A3 I get 2.
If in A1 I have 10/03/13 but A2 is empty, I would like to have an empty cell.

Thank you in advance for your responses.

3 answers

  1.
    PHILOU10120 Posted messages 6463 Registration date   Status Contributor Last intervention   835
     
    Hello

    a solution 

    =IF(OR(A1="";A2="");"";NETWORKDAYS(A1;A2))


    6
    1. TITI66MATH Posted messages 5 Status Member
       
      Thank you very much.
      Your formula works great.

      However, I would also like the calculation not to be performed if the date contains the letter A.

      Example: in A1 I have 10/12/13 and in B1 I have 12/12/13A. I would like to have an empty cell in C1 as a result.

      Thank you.
      0
    2. TITI66MATH Posted messages 5 Status Member
       
      Thank you all for your responses.
      0