asked on

Hide the date value

Hi Experts,

I need Experts help. How to hide the date value at Column L and N and only displayed once we typed “X” at column B: J?

Project-Report-test.xls

DonkeyOte

Some of the dates in L appear to be manual entry so you not entirely clear but in general you can use a pre-emptive COUNTIF test, ie:

=IF(COUNTIF(B4:J4,"x"),calculation,"")

Does that help ?

Ingeborg Hawighorst (Microsoft MVP / EE MVE)

Hi Theva,

use an IF statement around your date calculation.

=IF(COUNTIF(B4:J4,"x")>0,IF(AND(O3<N3,O3<>""),O3+1,N3+1),"")

see attached.

cheers, teylyn

Copy-of-Project-Report-test.xls

SOLUTION

sandeshj

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Theva

ASKER

Hi teylyn,

Have checked the file, it shows #Value! at Column O,P and Q. How to prevent this?

ASKER CERTIFIED SOLUTION

Ingeborg Hawighorst (Microsoft MVP / EE MVE)

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Theva

ASKER

Hi,

Thanks for helping me.

Ingeborg Hawighorst (Microsoft MVP / EE MVE)

Thanks for the grade, Theva.

I'd strongly advise against using the conditional formatting solution you accepted as an assist, because the values will still be in the cells and will be calculated (wrongly) into your results, even if they are not immediately visible in the sheet.

cheers, teylyn