Excel2003 ... Networkdays?

My Ranges (format = custom €œd€�):

A15:U20
A23:U28
A31:U36
A39:U44

Cells in my Ranges might contain:

Spaces ... (at beginning &/or end of each Range)
Empty Cells ... (at beginning &/or end of each Range)
A single apostrophe ( €˜ ) ... (at beginning &/or end of each Range)
Text (1-3 characters) ... (anywhere in Range)
Dates (format = custom €œd€� ... anywhere in Range)

Cell €œY1€� contains a date (01/01/09)

What I wish to calculate is:

Networkdays between 01/01/09 & Today ... minus any weekday dates which
contain the 1-3 character Text (exclude: empty cells, spaces & single
apostrophe which are @ the beginning &/or end of each Range)

Any solutions? ... Thanks ... Kha

Yes. The solution is to create a range (typically called Holidays) which
Excel will recognize. Then use this range in your Networkdays formula.

Remember, formatting doesn't change the underlying data. If you have a
proper date, it doesn't matter how it's formatted (ie, "d", "mm/dd/yy",
etc.). Networkdays will still recognize it as a date.

Regards,
Fred.

"Ken" wrote in message
...
Excel2003 ... Networkdays?

My Ranges (format = custom €œd€�):

A15:U20
A23:U28
A31:U36
A39:U44

Cells in my Ranges might contain:

Spaces ... (at beginning &/or end of each Range)
Empty Cells ... (at beginning &/or end of each Range)
A single apostrophe ( €˜ ) ... (at beginning &/or end of each Range)
Text (1-3 characters) ... (anywhere in Range)
Dates (format = custom €œd€� ... anywhere in Range)

Cell €œY1€� contains a date (01/01/09)

What I wish to calculate is:

Networkdays between 01/01/09 & Today ... minus any weekday dates which
contain the 1-3 character Text (exclude: empty cells, spaces & single
apostrophe which are @ the beginning &/or end of each Range)

Any solutions? ... Thanks ... Kha