Networkdays?

[Ken]

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

 

[Fred Smith]

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.