Forum Discussion

DnGr's avatar
DnGr
Copper Contributor
Dec 31, 2024

Date

I have this formula that returns the total days =NETWORKDAYS.INTL(E19,F19,"0000000")

If I have dates (E19)12/01/2024,(F19)12/2/2024 the formula returns a value of 2, which is what I want,.

What I need is if a date is not entered in either of the cell, I want the cell to remain blank.  How do I accomplish this?  I have tried the if function multiple ways but have been able figure it out.

  • DnGr's avatar
    DnGr
    Copper Contributor

    Thank you for your help.  I need to make continue to work on conditional formatting and formulas for the form I am working on.

    I will review online on creating a macro for the form.  I will take a look some the discussions that have taken place in the community forum.

    Thanks again

Resources