Hiding a cell with a formula.

B

BMoran

I have the following formula: =WORKDAY(A56,5,Due!$H$1376:$H$1390)

If column A has a value, then the column with the formula returns a date.
However, if column A does not yet have a value (but will in the future) then
the column with the formula returns with 01/06/00. How can I get the column
with the formula to remain blank if there is not yet a value in column A?

Thanks!!
 
J

Jacob Skaria

Use the IF()..

=IF(A56="","",WORKDAY(A56,5,Due!$H$1376:$H$1390))

If this post helps click Yes
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Consecutive date calculation involving holidays 1
Function Help - Forecast Date past due, adjacent cell is blank. Needto highlight the blank cell. 2
Count entries in the column translating to minutes. 5
With F1 value, look at A, if match or partial match return B 5
#value error for sumproduct using RIGHT cmd 0
help with formula for last input in column 6
Return a value from Chart 1 depending on the value typed into char 1
Formula to display text depending upon date entered in a cell 2

Top