How To Make A Cell Blank

[sealion1]

Hi,

Can someone please help me with this problem.

I have put a date in the "Stage Date" column and have set up a formula already to calculate the date when the next stages would be due.

However, if there is no date in the "Stage Date" column, I want the cells E & G to stay blank.

Please find attached a copy of the file.

Any help would be really appreciated.

Thank you!

 

[Smallman]

Hi Sealion1

In E2 put the following formula

=IF(C2="","",WORKDAY(C2,D2)+2)

In G2 put this

=IF(C2="","",WORKDAY(E2,F2)+2)

That should cover off your blank issue.

Take care

Smallman

 

[Khalid NGO]

Hi,

Further to Sir Smallman; another way is:
Select both range >
Use Conditional Formatting > formula: =ISBLANK($C2)
Format Cell > Font Color = white

Regards,

 

[sealion1]

Thank you both