Formula for blank fields

[Steven1985]

Hi

I have a formula to count between 2 fields
=WORKDAY(AH3,1,Controls!$F$8:$F$45)

I need to include within this formula, if column AH is 'BLANK' then AM will be blank.

At the moment if AH is 'BLANK' AM Shows a date 02/01/1900.

Can anyone help?

Thanks

 

[Aladin Akyurek]

Hi

I have a formula to count between 2 fields
=WORKDAY(AH3,1,Controls!$F$8:$F$45)

I need to include within this formula, if column AH is 'BLANK' then AM will be blank.

At the moment if AH is 'BLANK' AM Shows a date 02/01/1900.

Can anyone help?

Thanks

Looks like...

=IF(AH3="","",WORKDAY(AH3,1,Controls!$F$8:$F$45))