Date function and blank cell 1

[vladk]

Hi,

I want in some date formatted column in Excel enter this formula:

=WORKDAY(F1,H1-1,Holidays!$A$1:$A$3)
....
=WORKDAY(F100,H100-1,Holidays!$A$1:$A$3)

(WORKDAY is available with Analysis tool pack add-in).

I also want NOT to display anything in that date formatted column if OR(ISBLANK(F5),ISBLANK(H5)). I don't want to see something like this: 01/12/00


How can I accomplish this?

Thank you

vladk

 

[vladk]

Correction:

I also want NOT to display anything in that date formatted column if OR(ISBLANK(F1),ISBLANK(H1)).... OR(ISBLANK(F100),ISBLANK(H100))

vladk

 

[xlbo]

=if(OR(ISBLANK(F1),ISBLANK(H1)),"",WORKDAY(F1,H1-1,Holidays!$A$1:$A$3))




Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[vladk]

xlbo!

Thank you!

vladk

 

[xlbo]

no worries - an empty string is always a good bet for non display as it can't be formatted as a number...

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question