|
Networkdays?
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 |
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 |
| All times are GMT +1. The time now is 04:37 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com