Sum working days
I am still getting NAME # error!
"Mike H" wrote:
Try this
=WORKDAY(A1,B1,Holidays)
Holidays is a named rtange that contains any holidaya dates.
If you get a NAME# error then
Tools|addins and load the analysis toolpak.
Mike
"NM" wrote:
Hi,
Column A has date, Column B has number of days required to finish the task,
in Column C I want to use a formula which adds Column B( number of days) to
column A but excludes holidays and weekends and adds only working days.
eg. Column A has 12/8/08 Column B has 7 days coulmn C should be 12/17/08 (
only working days to be added)
Thanks for your help.
|