Forum Discussion
Only show if there is a date in column
I want to only show the $ amount in Column A if there is a date. Everything I try I get an error. Here is the formula that I have that is totaling the amount now but the same amount shows all the w...
Excel treats dates as real numbers and there is no function called ISDATE in Excel, though VBA contains a function called IsDate().
You may replace your function with the following one to see if that returns the desired output.
=IF(ISNUMBER(A3),D2+B3-C3,"")
You're welcome! Glad it worked as desired.
Please take a minute to accept the post with the proposed solution as a Best Response to mark your question as Solved.