Networkdays?
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
|