Attempting to create an IF formula

[jbiebs303]

I'm trying to create an IF formula (or better if one is available for this scenario) to calculate how many days has passed by based on dates in Column A & Column Q. I have the formula set where if there is a date in Column A but not in Column Q, it will still calculate the days passed. However, if there is no date in Column A, it is still calculating the days, which in the screenshot is showing 44450. I need the cell to be blank if there is no date entered in Column A. I tried an OR function, or adding an ISBLANK but that didn't seem to help, or I didn't type it correctly. Can someone help please and thank you! Using Excel 2013.

[#2 · Accepted solution]

@jbiebs303 

That could be

=IF(A3="", "", IF(Q3="", TODAY() - A3, NETWORKDAYS.INTL( A3, Q3, 11) ) )

[#3]

Thank you! I figured I was putting too much effort into it, need to remember simpler is better. I appreciate you!

[#4]

@jbiebs303 , you are welcome, glad it helped