Hiding a cell with a formula.
 

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!!

Hiding a cell with a formula.
 

Use the IF()..

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

If this post helps click Yes
---------------
Jacob Skaria


"BMoran" wrote:

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!!

Hiding a cell with a formula.
 

One way...

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

--
Biff
Microsoft Excel MVP


"BMoran" wrote in message
...
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!!