Forum Discussion
DnGr
Dec 31, 2024Copper Contributor
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.
=IF(OR(E19:F19=""), "", F19-E19+1)
- DnGrCopper 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
=IF(OR(E19:F19=""), "", F19-E19+1)